How to Secure Access 2003 Database transferred to a different PC

[Guest]

Dear All,

I have created an Access database using MS Access 2003, followed all the
security steps using the Workgroup, creating an admin user, removing the
default admin from the admins group etc and the security works fine on my
machine.

Now when I transfer the mdb file (database) to another machine, the user can
just right pass the security without even having to enter the login
information. He can play with the tables, edit delete do everything.

How can I avoid this from happening, note this not a application, it is just
the access database and there is no application as such.

Any help is greatly apprecicated on this topic

Thanks
Shailesh

 

[Joan Wild]

If the user can do that, then you missed a step in securing it. If done
properly, they won't be able to even open the mdb without using the correct
mdw.
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

 

[Guest]

Thanks Joan. I was able to get this working.

If the user can do that, then you missed a step in securing it. If done
properly, they won't be able to even open the mdb without using the correct
mdw.
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm