Prevent User From Import My Table

  • Thread starter Thread starter cambo
  • Start date Start date
C

cambo

Hello All Experts
I want prevent user from import my table in ms acess database.
How should I Do?
please help.

Thanks in Advance.
 
It would depend upon the version of Access you are using, and who the user
is, and what permissions the user has.

In Access 2003 and earlier, and using an MDB format in Access 2007, you can
set up and use User-Level Security:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm

If you do that, you can not allow the user any permissions on the tables
except through OWNERACCESS OPTION queries. The user could still copy the
table, but he/she couldn't open them.

As an aside, users who are malicious or steal data need to be fired. If you
can't trust them to do the right thing with your data, you cannot trust them
to do anything else.
 
Sounds like maliciousness and hostility in the workplace...

1. Prefix all of your table names with the characters "Usys"
2. Turn off "View System Objects
3. If your application is split, you'll have to re-link the back end.
and hide system objects in both FE and BE.
4. Put an Autoexec macro in the BE and turn off the "Allow Bypass
.....". That's to prevent others from getting into the BE directly.

To really mess up anyone getting at your data you might leave a
complete set of tables with the original names but with corrupt or
stale data...

HTH
 
I don't think any of that would prevent me from importing that table into
Excel.

Password protection is the only route, and if the user has password access
nothing can stop them from copying the data if they know how to get to it.
 
You're so right. Thank you.

I used those methods so long ago that I forgot the circumstances.
They were used to defeat the curious and busybodies who were using
Access to do their evil deeds

Secure the database and possibly encrypt it?

HTH
 
User-Level Security, as I outlined it above, and setting the permissions to
none will keep all but the most determined out of the data. Then use
WITHOWNERACCESS queries to read what you want them to.

I would also use NT security logging to determine file accesses. If you find
that someone is copying the file illegally, you fire them and prosecute.
There is no room in any company for miscreants.
 
Back
Top