'Exclusive Access to the database' error

[Andy Calder]

When i try to make design changes to my tables using
Access 2000 connected to MSDE, i get the error " you do
not have exclusive access to the database at this time".

Any ideas?
Note: I am using SQL2000 SP3

Thanks

 

[Jerry Boone]

You can only have one instance of your ADP file open at any time.

If you are deploying it to multiple users, you need to make a copy of it for
each user and preferably deploy it to thier hard drive by login script,
bootup, or on demand.

If you are on Win2k or XP, open "Computer Management" from the admin tools
in the control panel and see what files are "open" or "in use". If it says
you have it open, check Task Manager and make sure all instances of
msaccess.exe are ended, then try again. If the file is on a server, you can
check it from there.

Make sure you have full permissions on the file and not read only -- some
admins like to change perm's when your not looking...

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access

 

[Andy Calder]

I checked and there seems to be only 1 instance running. i
tried connecting remotely and i was able to make design
changes but i am still not able to make design changes
locally?

 

[Andy Calder]

I solved the problem. When using SQL Server 2000, you must
have Office 2000 SP2 or Access 2000 SP2 or higher to save
changes to the design. SP1 doesn't allow changes to be
saved.