Database Locking

[SeeWard]

I have created a database that is used by multiple end-users. When they try to access it, it tends to freeze and states that it's locked by admin...Any suggestions? Thanks SO MUCH...MANY THANKS!

 

[Blorf]

If while in the d/b you open for design mode a form, report, or module, it will lock it.

Any change that's what happening?

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[SeeWard]

Hi! Thanks for responding...no, it's not in design view at all...neither tables nor forms... I am now checking machines to see if the default open mode is set to shared and if the record locks are set to either no locks or edited record...???

 

[SeeWard]

Ok had a 'phantom' user ...I deleted the locked file and now it works! Thanks!

 

[ProgramError]

Ahhh the dreaded phantom....

You can always check which computer is locking the DB by opening the locking file with notepad. Not useful, but mildly interesting.

Ian M (UK)


Program Error
Programmers do it one finger at a time!

 

[SeeWard]

Nifty! Thanks! I will do that....!

 

[severin]

http://www.tek-tips.com/viewthread.cfm?qid=1068969&page=1