Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Concurent Use of Access Project

Author  Topic 

kaus
Posting Yak Master

179 Posts

Posted - 2002-04-02 : 13:48:07
I have an access project linked to SQL Server Database. Whenever more than one person opens the project an error appears:
'the file is locked for editing by another user, or the file is locked as read only'

Thankfully, If you dismiss the message and make edits, the edits are included --

What may be causing the error and how might I go about correcting it ?? I'm kind of thinking I should have used VB instead of Access for this

Thanks
Pete

kaus
Posting Yak Master

179 Posts

Posted - 2002-04-02 : 14:25:51
It wont let me change code -- so the message seems to be refering to this -- I'd still like to find out how to stop this message, however, so the users dont get excited

Pete

Go to Top of Page

kaus
Posting Yak Master

179 Posts

Posted - 2002-04-02 : 15:53:36
I seem to be the only one responding to this, but I checked Knowledge base at Microsoft -- According to Q296263, they recommend that you provide each of your users with their own project file. It still would be nice if I didnt have to do that -- oh well

Pete

Go to Top of Page

Doug G
Constraint Violating Yak Guru

331 Posts

Posted - 2002-04-03 : 18:00:16
I see the same behaviour.

======
Doug G
======
Go to Top of Page
   

- Advertisement -