Solved

Prevent Tables and Queries from being imported from Access File

Posted on 2011-09-25
7
1,343 Views
Last Modified: 2012-05-12
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
Comment
Question by:RDLFC
  • 4
  • 3
7 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 36594597
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
 

Author Comment

by:RDLFC
ID: 36602526
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
 
LVL 77

Expert Comment

by:peter57r
ID: 36707722
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:RDLFC
ID: 36709725
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
 

Accepted Solution

by:
RDLFC earned 0 total points
ID: 36815598
For any users following this question see the link below.

http://www.vbforums.com/showthread.php?t=350669
0
 

Author Closing Comment

by:RDLFC
ID: 36908418
I found a solution
0
 
LVL 77

Expert Comment

by:peter57r
ID: 36898811
Nothing in the 'solution' you have found prevents anyone from doing anything.  It just hides things.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question