Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / SQL Server / ADP / October 2003

Tip: Looking for answers? Try searching our database.

Exclusive Access Error Message

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ChelleV - 13 Oct 2003 14:20 GMT
I have a SQL 2000 backend, with an Access 2000 Project
frontend, and the frontend file is saved on each person's
private drive.  (3) users are assigned dbo rights.  (1)
user has successfully created views using the Access 2000
Project interface.  However, another user continues to get
this error message when going into design view for
creating a view:

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

It allows her to design it, but she can't save it and
therefore can't run it.  I have double checked her SQL
role and rights, she is dbo and no rights are denied.  The
Access Project is saved on her personal drive, so no one
else has access to this file except for her.  

Any ideas?  I appreciate your feedback!
Vadim Rapp - 14 Oct 2003 05:38 GMT
C> I have a SQL 2000 backend, with an Access 2000
C> Project frontend, and the frontend file is saved on
C> each person's private drive.  (3) users are
C> assigned dbo rights.  (1) user has successfully
C> created views using the Access 2000 Project
C> interface.  However, another user continues to get
C> this error message when going into design view for
C> creating a view:

Check out these articles:

http://support.microsoft.com/?kbid=269824 (most likely)

http://support.microsoft.com//?kbid=313253

Vadim

----------------------------------------
Vadim Rapp Consulting
SQL, Access, VB Solutions
847-685-9073
www.vadimrapp.com
ChelleV - 15 Oct 2003 16:11 GMT
Thank you for your response.

All users already have Client Tools installed on their
machines.  The SR/SR1 update won't fix the error message
we're getting, either.

Any other suggestions?  I would certainly appreciate it.

Thanks,
Michelle
>-----Original Message-----
>C> I have a SQL 2000 backend, with an Access 2000
[quoted text clipped - 20 lines]
>www.vadimrapp.com
>.
Vadim Rapp - 16 Oct 2003 03:39 GMT
C> All users already have Client Tools installed on
C> their machines.  The SR/SR1 update won't fix the
C> error message we're getting, either.

C> Any other suggestions?  I would certainly
C> appreciate it.

I would run Profiler in order to catch what failed on the server.

Vadim
----------------------------------------
Vadim Rapp Consulting
SQL, Access, VB Solutions
847-685-9073
www.vadimrapp.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.