Denying Permission to Export Tables 1

[farzinkh]

Hello and thanks for your help. Is there a way in MS Access to give the user permission to view a table , but NOT to export the table in to EXCEL or another database?

 

[MrDataGuy]

If you can view information on the screen then one can export/get it into another data format, think screen scraping or even print screen, then optical character recongnition. So the bottom line answer is no you can not stop someone from exporting the information (In both mt opinion and professional experiance), however it is possible to make it more difficult.

One idea is to show the information not as a standard table browse but as a report or a screen only view (think about a grid) Again if someone has the time or pays me to do it (and I have done this sort of thing in the past for clients) etc. the information can be still be 'exported"


Lion Crest Software Services
Anthony L. Testi
President

http://www.LionCrestSoftwareServices.com

 

[farzinkh]

Thanks , Is there a way to let a used view a Table only through a Form and not be able to directly open the Table?

 

[randy700]

If you provide the user with an mde version (Access 2003 and before), the tables are not accessible.

Randy

 

[boblarson]

If you provide the user with an mde version (Access 2003 and before), the tables are not accessible.

That is INCORRECT Randy. You can access (even change the structure of) tables and queries in an MDE file. It only keeps you out of the forms, reports, macros, and modules design views. It does not keep you from viewing the tables or queries if you have access to the database window (or Nav Pane in 2007/2010).

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[MrDataGuy]

farzinkh
Can you be a little more detailed why you want to prevent copying? And how much information needs to be protected?

Might it be better/possible just to hard code the information into the program (Assuming the information is readonly that is) or maybe the solution is to encrypt the data so that the user could see/copy it but it would be of no/little use to them. Another possibility is to encrypt a none database file say a XML file. Just trying to think outside of the box.

Lion Crest Software Services
Anthony L. Testi
President

http://www.LionCrestSoftwareServices.com