Solved

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

Posted on 2004-04-30
1
281 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 250 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

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

Suggested Solutions

Title # Comments Views Activity
Access 2016 importing text files 13 21
Top 1 of each supplier 55 56
VBA SQL statement - 2 "OR"s and 1 "And" 4 27
Dcount help 2 14
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…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

773 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