?
Solved

How to plug up security loop hole in linked tables?

Posted on 2002-05-30
8
Medium Priority
?
272 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
7 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

840 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