Change security access to a mdb

[Jac]

Hi we have a database that is associated with a mdw file

In the database i have my user "jefrguen"
Im the administrator and i create a new user "lorrbarr"

When im log with my user in windows AD jefrguen and i try to open the mdb, i
can access it with the user jefrguen and the new one i created "lorrbarr"

But if im log in windows AD with the user lorrbarr and that i try to open
the mdb file, it complain that i don't have access to that file. It dont
even ask me for username and password

Anyone can help me please

Thanks

Jac

 

[John W. Vinson]

Hi we have a database that is associated with a mdw file

In the database i have my user "jefrguen"
Im the administrator and i create a new user "lorrbarr"

When im log with my user in windows AD jefrguen and i try to open the mdb, i
can access it with the user jefrguen and the new one i created "lorrbarr"

But if im log in windows AD with the user lorrbarr and that i try to open
the mdb file, it complain that i don't have access to that file. It dont
even ask me for username and password

Anyone can help me please

Thanks

Jac

Either use Tools... Security... Workgroup Administrator to Join the .mdw file;
or use a shortcut to open the database, specifying the .mdw file in the
command line switches.

See the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Security is a complex task, and it would appear that you may be missing some
important bits!