Using Access 2000 .adp with SQL server 2000 database problem

S

smartbs

I have an Access 2000 .adp file that is connected to a SQL Server 2000 database. When I try to create a new view or table, I get a "You do not have exclusive access to the database at this time, your changes will not be saved." Or something very similar. The thing is, I am the only in the database, except maybe the administrator access on the server. Is that the problem? Or is it something else? It seems like I should be able to create a view without a problem. Any thoughts/recommendations would be appreciated. I have tried the KB and nothing is there. Or even is there a better place to ask .adp questions. Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Access 2000 ADP and SQL Server 2005 2
Data provider could not be initialized 1
link a table using an .ADP access application 1
Does Microsoft recommend databases or projects to connect to SQL s 1
Access 2007, SQL 2000 3
Server error 262 create data base permission denied in database ma 0

Top