protecting the back-end database

A

AccessHelp

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.
 
J

John Vinson

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
Protecting Word 2019 document 0
Access Lock File .LACCDB / Now shows as a notepad file 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Autonumber records inserted in gaps 0
Linking Multiple Front-end Database Files 3
Back end database on Internet 1

Top