Login Promblems

[heller]

I have a secured DB here in a multiuser environment.
Now it occasionally happens that I can't log in and access tells me: You or another user may have unecpectetly quit ms access while a MS Access Database was open. Do you want to MS Access to attempt to repair the database.

next message is then that I am myself have access opened with exclusive access. Which is not the case as i just want to log in. If every other user is logged out, it works again. Have no idea why and any help would be very welcome.

Thanks

 

[Len Boorman]

Have had similar type problems

Basically I think that the whole issue gets confused.

Is there by any chance say an Acc 2000 version with linked tables to an ACC 97 backend

I am not much help here but check that all users have full network permissions. Read Write modify delete

L

 

[The_Doc_Man]

When this happens, open a new window (if you can) to browse the folder in which your .mdb resides. Look for the .ldb file. It should be there.

Now go back to Access and exit. See if the .ldb file goes away. It should, but if it doesn't, you might have a problem. Now, the trick is that you must call every potential user to ask if they are in the .mdb file at the time.

IF AND ONLY IF you call everyone and they categorically deny being in the .mdb file AND the .ldb file is still there, delete it. If even one user is still in the .mdb file, the .ldb SHOULD exist and you CANNOT safely delete it.