Solved

How to plug up security loop hole in linked tables?

Posted on 2002-05-30
8
222 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

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…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
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.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

914 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

15 Experts available now in Live!

Get 1:1 Help Now