Get External Data - Prevent - Security (1 Viewer)

[hudson426]

Hi all

I am been searching for a while for a solution to my issue but cant find it anywhere. Any help would be greatly appreciated. Here goes....

OK, I have disabled the F11 key as well as the Shift Bypass, hidden the menus and restricted the access to the design of the forms. So its secure from prying and meddling eyes. However, I have come across a gaping hole in my attempt to secure the DB. To bypass all these controls all a user has to do is the following:-

Create a new DB
Get External Data
Import key tables etc

How do I prevent this from happening? I get the argument about what am I securing, is it worth it etc, etc, but surely there must be a way to prevent someone from simply importing tables and forms from one DB into a blank one. Any suggestions?

I am using Access 2010.

Cheers

 

[Isskint]

Have you thought about encrypting it with a database password? Without the password you can not get to the database from another database using Get External Data.

 

[arnelgp]

never tried but you can try to compile it into .exe

 

[emad981]

I saw the same in a sample database offered by someone for free but he locked importing external tables.
He assigned a password to the VBA codes.

I don't know if this is the solution or not, but at least it worth trying.