• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

how to merge back lookup tables

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
HalCHub
Asked:
HalCHub
  • 2
1 Solution
 
aikimarkCommented:
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
 
HalCHubAuthor Commented:
isn't that going to break all the queries that use the linked tables
0
 
aikimarkCommented:
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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now