Solved

Prevent Tables and Queries from being imported from Access File

Posted on 2011-09-25
7
1,285 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

910 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now