Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

how to merge back lookup tables

Posted on 2014-07-23
3
Medium Priority
?
202 Views
Last Modified: 2014-07-29
Access 2013 - 2 mdb files Main and lookup.  Mail uses lookup for drop down boxes.  I would like to merge them back into 1 mdb with out having to rewrite all the code and queries.

Can this be done ?
0
Comment
Question by:HalCHub
  • 2
3 Comments
 
LVL 46

Expert Comment

by:aikimark
ID: 40215917
are they attached (linked) tables?  If so, then your code doesn't need to change.  Detach the tables and import the tables with their original names.  Your application shouldn't know the difference.
0
 
LVL 1

Author Comment

by:HalCHub
ID: 40223278
isn't that going to break all the queries that use the linked tables
0
 
LVL 46

Accepted Solution

by:
aikimark earned 720 total points
ID: 40223288
No.  The queries get to the tables by name.  If the attached tables have the same name as your current tables, they should function the same.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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.
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.
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. …

927 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