adp connection to msde and exclusive rights

T

TJS

I am attempting to create a View from MS Access 2000 SR-1 to an MSDE 2000
(SQL Server 2000 Desktop Engine) database . I accessed with exclusive rights
but I get the following errorwhen trying to create a view:

"You do not have exclusive access to the database at this time. Your design
changes will not be saved."

how can I get ability to create views ?
 

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

Data provider could not be initialized 1
Access 2007 can't connect to SQL Server 1
Exclusive Access - How is it set? 4
Office 365 Outlook adding unwanted HTML to Email Body 0
Access 2000 & SQL Server 2005 3
Exclusive Access 2
ADP connection to MSDE 2
Access Runtime .adp To MSDE? 5

Top