Diff Version of same Access DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to set up two slightly different version of the same access
database on on our server. The only difference between the two is that I
want the "Managment Form" button on the switchboard on one of them to be
disabled, so the customer service people can't look at it.
I saved two Identical copies on the server and disabled the switchboard
button on one copy and gave it a different name.

Here's the strange part. Even though the databases have two different
names, when I change the switchboard on one, it makes the same change on the
other database with a different name. It's driving me crazy.

What can I do?
 
The switchboard data is saved in a table. That table may be in your shared
backend.

The bigger issue here is that disabling a button on a switchboard does
nothing to keep people out. What would prevent your users from opening the
tables and looking at (or changing) the data? What prevents them from
adding their own queries (update query, delete query?)? Or, what prevents
them from simply running the reports from the database window?

If you want to prevent users from getting to specific data, then you need to
secure your database.

Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

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



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm
 
Back
Top