Importing different tables depending on user imput

[Rowland]

I have a front end of a database and a back end of a
database in two different files. One holds the tables
and one holds the forms, querys and other stuff. there
are actually two back ends to this database however (two
table files) because one holds information for companies
and one holds info for residences. so they can both use
the same front end cuz they both hold the same kind of
info, I just want them seperated.

Here si my problem, when you open the database I have a
dialog that pops up asking if you are working with
business's or Residents. and depending on what they
click on determins the tables that will be imported.
I am using a switch to find what option was chosen, but I
dont' know the syntax to import the tables, can someone
help me with this please.

Rowland.

 

[Jeff Boyce]

Rowland

First, you probably won't be "importing" the tables, as that implies copying
from the backend to the frontend -- I suspect you are trying to link to the
backend tables.

Second, why go to all that work?! If your frontend already links to both
backends, your button on startup can just point to a form (or forms) that
relate to the respective set of tables.

Finally, there is no need to keep two backends. It isn't at all unusual to
use one Access database (backend & frontend) to work on more than one
thought.