Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1843
  • Last Modified:

Prevent Tables and Queries from being imported from Access File

I created a accde file to prevent users from viewing or modifying the code in my access database.  However when I create a new access file and use the import objects feature I can import tables and queries from the accde file.  How can I prevent this from happening.

0
RDLFC
Asked:
RDLFC
  • 4
  • 3
1 Solution
 
peter57rCommented:
There are not many options  to secure data in Access.

With an accdb file you can apply a database password and for this to be effective you need to split the database into front-end and back end and apply the password just to the backend.  
Then in your frontend code you can create the links to the backend tables when you open the (frontend) database and delete them all when you close, so that the user is not required to know the password to the backend.
The linked tables should be hidden so that they are not apparent should the user find their way to the navigation pane.

The password in A2007/A2010 is strong .  

It would be needed by anyone who tried to import the tables into a new file.

However, if data security is a primary requirement for you then you consider not using an Access database as the file store.
Maybe use a server database such as SQL Server (express edition is free) where there is a more powerful security model available, although getting to grips with it would not be simple.
0
 
RDLFCAuthor Commented:
thanks for the reply.  I currently have an access front end and a SQL backend.  I have ODBC connections established in the front end and a user can import the odbc table connections to another database.

if I password protect the front end will that stop the tables from being exported with the user needing to know the password?
0
 
peter57rCommented:
As far as I know, there is no way to stop authorised users from exporting tables. I assumed you were trying to protect against UNauthorised people trying to access the data.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
RDLFCAuthor Commented:
any user at all.  An athorised user can access the database through the front end but I want to stop all users from creating a new database and importing the linked tables from the front end.
0
 
RDLFCAuthor Commented:
For any users following this question see the link below.

http://www.vbforums.com/showthread.php?t=350669
0
 
RDLFCAuthor Commented:
I found a solution
0
 
peter57rCommented:
Nothing in the 'solution' you have found prevents anyone from doing anything.  It just hides things.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now