Solved

Prevent Tables and Queries from being imported from Access File

Posted on 2011-09-25
7
1,554 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

 

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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

617 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