Multi user database

Hello VB users,

Is it possible to create in MS Access a multi user database?

If yes, how do I do that.

Nice regards,

Michelle.

Hi!

Again I don't know exactly what you mean but I know that it's possible to open a .mdb file with more than one Application at a time.
(up to ten should be no problem)

Opening the Db with Jet and ODBC sometimes a deadlock ocurred (in the application that worked with ODBC).

Be aware of the limited capabilities of .mdb-databases.
They get very slow with some data in them.

Hope this helps you :p
Regards,
da_bob
___________________

Hello da_bob,

Thanks for your information.

Michelle.

if ur writing a program which updates the records in a database and you are going to have multiple users accessing at the same time (ie data entry teams) be aware that the default record locking should be set to edited records, and the timeout and retry values should be set a bit higher than default. Both these settings are under Tools, Options, Advanced.