protecting the back-end database

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

Guest

I have a back-end (BE) database and many front-end databases. If I have my
BE in a shared drive, what are the ways that I can protect my BE from people
getting into the database and tables in the database?

Thanks.
 
I have a back-end (BE) database and many front-end databases. If I have my
BE in a shared drive, what are the ways that I can protect my BE from people
getting into the database and tables in the database?

Thanks.
Click to expand...

One quick and dirty way is to have an Autoexec macro which simply
quits.

Linking to the tables won't fire it, but opening the database will.
This will keep out the curious. You can disable the Shift key to keep
out the malicious provided they're not too expert in Access.

John W. Vinson[MVP]
 
Back
Top