If you only want one user at a time to connect to the database,
the easiest way is to open it exclusively. In DAO, this can be
done by supplying True as the second argument of OpenDatabase.
If the database is already opened by someone else, it will
trigger an error.
Quote:
>Hi,
>How can I lock a jet DB for other users?
>I have two computer in a network, both computers use a VB program that
>is inatalled on both computers.
>Both computers use the same databases on a server.
>How can I detect that a database is in use?
>And how can I set a database as used?
>pls help
>Thanks,
multi user with jet DB