Solved

how to merge back lookup tables

Posted on 2014-07-23
3
186 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 45

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 45

Accepted Solution

by:
aikimark earned 180 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now