Access Won't allow multiple users to login

[gavinjb]

Hi,

Recently I have been having problems on partiucular PC's when the user logs into any of my access 2000 databases, no one else then can login, has anyone else had this problem and know how to resolve it, I have looked through all the options but cant find anything that could impact this.

Thanks,

Gavin,

 

[lupins46]

Two related possibilities spring to mind immediately.
1: the first user in is doing some design work - this would automatically switch to exclusive access mode and prevent anyone else opening the database
2:the first user is opening the database in exclusive mode as the default open mode: look at Tools>Options>advanced and make sure it is set to Shared.

 

[KenReay]

Hi

A third possibility for you, have you been changing Network access permissions in the relevant folders, users must have full rights in folder where Accessmdb is located to allow for create/update/delete of teh lock file in that folder

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[gavinjb]

Thanks for your suggestions I have checked them all and none of these apply.

Gavin,

 

[lupins46]

When one user has the database open is there a .ldb file in the database folder with the same name as the database?

 

[gavinjb]

http://www.tek-tips.com/viewthread.cfm?spid=181&newpid=181&sqid=874309

 

[gavinjb]

yes, the ldb file is being created. Gavin,

 

[gavinjb]

Sorry I just posted the wrong thing, my Pc is playing up.