Thread: Multiple Users NOT able to log in

I have a database that is giving me fits, I wrote it. The only way it will let multiple users log in, is if everyone logged in is at the switchboard. If anyone is anywhere else in the database it won't let more people log in. Any ideas or suggestions would be greatly appreciated. I do have a login script that checks password to user name. I can post it if you would like. It is very basic atm.

Thanks in advance,

Dan

Hi Dan,

Not speaking for 2007 (I'm still happily in denial), but in 2003 under Tools > Options "Advanced" tab, there are choices for "Default open mode", "Default record locking", and "Open databases using record-level locking". If any of your users have modified these options in their local copy of Access, then it could give you grief. A common one that has plagued me in the past is users who like the word "Exclusive".

Cheers,

I checked that already. They are all set to edited record only.

Since this post I have re-written all the code for security. One major thing to note is if you have a database that isn't using unbound forms, and multiple people are using it at the same time, avoid using Dlookup and DlookupWrapper like the plague. At the time I posted this I didn't know it would actually log you in if you waited. It took about 10 mins to log in though. I am currently using Optomistic locking and SQL strings and ADODB.Recordsets.