PDA

Click to See Complete Forum and Search --> : Multi user database


michelle
Jun 13th, 2000, 03:28 PM
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
Jun 13th, 2000, 06:29 PM
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