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
Solved

How to plug up security loop hole in linked tables?

Posted on 2002-05-30
8
242 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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 Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server views 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 Microsoft Access…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

809 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