Solved

How to plug up security loop hole in linked tables?

Posted on 2002-05-30
8
234 Views
Last Modified: 2008-02-01
I have a backend database that is password protected, so if someone creates a new database and then tries to link to it, they have to have a password.  I have a front end mde file linked to the backend database.
Now if someone creates a new database and then imports the tables from the mde file, they can do so without supplying a password and have accomplished the same thing as linking to the backend database.
I am trying Not to make the users have to enter a Password for the mde file.  Does anyone have suggestions on preventing users from importing the linked table settings from an mde file?
0
Comment
Question by:Mach1pro
  • 2
  • 2
  • 2
  • +1
8 Comments
 
LVL 2

Expert Comment

by:perfittl
ID: 7046723
If you use microsoft's security that is built into Access, then you can hard-code the password you choose into your front-end application.  Anyone attempting to link to the back-end will then still require a password.  Anyone using your front-end application will not require a password other than the one you've built.  I'd be happy to send the code if you need more assistance.

Hope this helps,

-Larry
0
 
LVL 6

Author Comment

by:Mach1pro
ID: 7046826
perfittl
Let me get this right... You're saying that I can have a password on the front end database, but the users don't have to enter the password to get the database open?
If that is the case, please send the code.
mel@mach1pro.com

Thanks!
0
 
LVL 54

Expert Comment

by:nico5038
ID: 7227030

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
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.

 
LVL 6

Author Comment

by:Mach1pro
ID: 7227124
Nico,
Go ahead and PAQ. I never got the answer I needed. What I finally had to do was create an mde who's only job is to open the frontend database which is password protected. The mde supplies the password in the opening form and since it is an mde, the forms code is not visible for anyone to see the password.
0
 

Accepted Solution

by:
Jgould earned 0 total points
ID: 7235454
moving to PAQ points refunded as per user request in CS

JGould-EE Moderator
0
 
LVL 54

Expert Comment

by:nico5038
ID: 7235488
Hi JGould,

When cleaning, checkout the cleanup Q's I've placed in the cleanup topic area. Some 50 Q's are overdue ;-)

Nic;o)
0
 

Expert Comment

by:Jgould
ID: 7235948
Nico I will do that later today starting oldest first :)
0

Featured Post

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.

Question has a verified solution.

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

Suggested Solutions

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…

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