My first steps on this forum : import tables

[Mat_F]

I have a MDE file with tables with data I want to keep
secret and to allow access under VBA control (through forms).

The problem is that anyone can import these tables !!!

(I already tryed to hide or rename as system tables but
this can't really hide the tables. I also disabled the SHIFT
key to prevent user to get the DB window)

So how can I prevent user to import a table ????
(strange how this simple problem can be a security weakspot !)

Thanx to anybody to answer my first question on this forum.

 

[Benny Wong]

Microsoft Access Security Issues?

Hello Mat_F,

In response to your issue, I am in the same boat. However, to cover your behind in light of the security holes of
Microsoft Access perhaps another way of looking at the security holes is if someone really wants to get in they will. Having said that maybe let management be aware of this and put the responsibility on their shoulders. This way you can rest easy doing your job as a programmer and not worry as a security officer. But that is my opinion. Someone once said, "Life is what happens to you while you are planning your life"
Hope that helps! Good Luck!

 

[pono1]

Mat and Benny,

You may want to start here and also search the forum using the keyword Security. Afterward, if you have the means, practice setting up security on a test machine with test files.

Regards,
Tim