Pulling my hair out with locking.

SQL Server 2000 - Backend
Access 2000 Runtime - Front End
Connecting via ODBC

I have read loads and loads of examples and looked at other sources of info for help on this but am struggleing big time.

I have multiple users working in the same database table. The problem is they often get an error message about the record has been changed and would they like to save the changes to clipboard etc etc.

I basicly want to implement pessimistic locking for my tables. So once a user has started to edit that record nobody else can get to it.

Can anybody help?

Many thanksHi

There can be reasons other than locking issues that cause this message. For example, if your table contains a Bit field which contains Nulls then it will cause problems in an Access linked table. I also recall reading that adding a Timestamp field can help out too.

HTH|||Sorry I should have put in the first post.

I have a Time Stamp field, a PK and have no Bit fields.

Cheers|||Does the Access--> Tools--> Options--> Advanced--> Default Record Locking --> Edited Record option help?|||Nope. Access treats all ODBC connections as 'No Locks'.|||Have you considered wrapping up your data access and editing in sprocs and disconnecting your FE? Many on this forum would advocate such an approach irrespective of the problems you are having. In that case at least you can handle concurrency issues within SQL Server (as well as further security benefits etc).

pubs in Desktop Version of SQL2ksp3

I'm using VS and I've been trying to do the examples on
the tutorial. As topic title suggested, I'm using a
desktop version of the SQL2k service pack 3. However, I
can't seem to make a connection to the pubs database. The
only database I get are master, model, msdb and tempdb.
What exactly should I do to get this working?
Thanks in advance. ^_^
hi,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:95e001c4338b$ba009e90$a501280a@.phx.gbl...
> I'm using VS and I've been trying to do the examples on
> the tutorial. As topic title suggested, I'm using a
> desktop version of the SQL2k service pack 3. However, I
> can't seem to make a connection to the pubs database. The
> only database I get are master, model, msdb and tempdb.
> What exactly should I do to get this working?
> Thanks in advance. ^_^
Pubs and Northwind sample databases are not present in the MSDE packages, in
order to limit thery deployment size...
you can actually get the database package at
http://www.microsoft.com/downloads/d...DisplayLang=en
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Pubs database for MSDE

I installed MSDE2000 on my Win XP Pro computer to run
through examples in a book. Some of the examples uses the
Pubs database which I cannot find in my MSDE setup. How
can I setup the Pubs database in my setup and where can I
download it from? Thanks.
We have just made a file available in the Microsoft Download Center that
contains scripts for creating the pubs and Northwind sample databases.
Go to http://www.microsoft.com/downloads
Select SQL Server as the Product and enter sample databases in the Keywords
field and click Go. You will see an entry for Sample Databases.
The direct link is:
http://www.microsoft.com/downloads/d...DisplayLang=en
From the download file readme:
These copies of the scripts are the same as the versions included with SQL
Server 2000, except for these changes:
a.. The script for creating pubs, instpubs.sql, has been modified to
install pubs and all of the pubs data in one step. The version of
instpubs.sql included in SQL Server 2000 does not load in some of the pubs
data, customers had to run batch jobs to install some of the larger data
values.
b.. The scripts improve security by not creating a guest account and not
assigning permissions to the objects in the sample databases. Customers who
install the sample databases can now control access to the sample databases.
SQL Server 2000 Desktop Engine (MSDE 2000) customers can also use these
copies of the scripts to install pubs and Northwind.
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights