Access 2000 ADP - "You do not have exclusive access"

[Guest]

When I try to create a new SQL Server object in any SQL Server 2000 database i get the following message: "You do not have exclusive access to the database at this time, your changes will not be saved." This error pops-up even though I am the only database user.
Access forms and reports can be saved.
I know others who have had this problem as well, but I can't find any reference to this as a bug and can't find a fix.

Any ideas?

 

[GVaught]

This may have to do with Permissions not set correctly at the server level
with either the Access 2000 db and/or SQL Server database. For Access you
must have read/write/modify/execute against the folder where the Access
database resides as well as against the database. If you also have internal
permissions within Access you may not have the appropriate level there also.

--
G Vaught

When I try to create a new SQL Server object in any SQL Server 2000

database i get the following message: "You do not have exclusive access to
the database at this time, your changes will not be saved." This error
pops-up even though I am the only database user.

Access forms and reports can be saved.
I know others who have had this problem as well, but I can't find any

reference to this as a bug and can't find a fix.

 

[Guest]

I am a sys admin within SQL Server and have local admin rights on the NT4 box where SQL server resides.