Exclusive Access Error Message

[ChelleV]

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]

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

 

[ChelleV]

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

 

[Vadim Rapp]

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