Solved

How to plug up security loop hole in linked tables?

Posted on 2002-05-30
8
253 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
[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
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

739 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