Multi user database

[michelle]

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.

[Ianpbaker]

Hi Michelle

Yes you can set up a multi user database.

The Bad news is that you have to create it from new and not update an existing one. This is because if some one else has already accessed the databas without login's they aoutomatically get administrive privalges.

To set up the users and groups is quite easy.

If you go to the tools menu, there is the security menu, and within there is the two options of users and accounts, and user and group permissions. First set up your users and groups, then assign their permissions.

As I said earlier if you want to update an existing database, create a new one and then import the tables. Then set up as above.

If you need any more help reply back

Hope this helps
Ian