MS Access Multiuser - Lock Database?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Lock Database?

2006-02-01, 11:25 am

I am running an Access 2002 database (split front-end and back-end) and would
like to LOCK the database on command (to update tables and avoid crashes for
inconsistency). Is this possible?

Please let me know, thanks.

G

Larry Linson

2006-02-01, 8:29 pm

"G" <G@discussions.microsoft.com> wrote

> I am running an Access 2002 database (split
> front-end and back-end) and would like to
> LOCK the database on command (to update
> tables and avoid crashes for inconsistency).
> Is this possible?

If you want to "lock" the back-end database, you can open it directly, for
Exclusive Use. There's no other approach, of which I am aware, to lock an
entire database.

Larry Linson
Microsoft Access MVP

Sponsored Links