Moving a database and retaining security

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 21 Apr 2004 18:51 GMT

I set up user-level security with my *.mdb file and it
worked great but when I tried to move the database to
another computer, the users and permissions were lost in
the transition. I created a system.mdw file and move it
with the database. I then opened the system.mdw file on
the new computer and it was empty. What did I do wrong?

Reply to this Message

GVaught - 22 Apr 2004 05:46 GMT

You have to join that secured workgroup on any computer in which it is
copied. Until you do that, you won't get the username and password prompt.
Note: a Secured mdw file should not be called System.mdw. When you create a
secured database always name the mdw different.

> I set up user-level security with my *.mdb file and it
> worked great but when I tried to move the database to
> another computer, the users and permissions were lost in
> the transition. I created a system.mdw file and move it
> with the database. I then opened the system.mdw file on
> the new computer and it was empty. What did I do wrong?

Reply to this Message