Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Need to make MDE but have external forms that link to tables

Posted on 2004-04-30
1
Medium Priority
?
317 Views
Last Modified: 2013-12-05
I have two MDB. Because on of them just sits in a loop watching barcode readers.   The other one allows the user to make changes/additions and deletions to one of the tables in the first mdb through a linked table.

I want to prevent the user from screwing up the program by making it a MDE. The problem is that the 2nd program(mde) can no longer access and make changes to the linked table that resides in the first mde.  

Does this make sense? Can you help?
0
Comment
Question by:jasgot
1 Comment
 
LVL 1

Accepted Solution

by:
dxve earned 1000 total points
ID: 10965032

One solution would be to make a third database used solely for the tables. You can then link to it from both the existing databases, which you can make mde's. Makes for a robust system and allows you direct access to the tables, for queries maintenance etc
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
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, 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 …

564 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