Multi files

  • Thread starter Thread starter Nathan
  • Start date Start date
N

Nathan

I have multiple Databases and what i want to do is create
a global database. each company has a folder which
contains their data base all the databases are named the
same. in this database i want a form with a list of
companys and a open button and when a company is selected
it opens the companys database and also a form to add new
companys, in which i want to be able to copy and template
folder and rename it based on a field in access. also be
able to edit existing companys


any suggestions?
thanks
 
Hi,


Keep it in just one database, adding an extra field, CompanyID, in
the appropriate tables?


Vanderghast, Access MVP
 
with the infomation in the table and the way i have
everything set up i would have to create 1 form 5 tables
and 5 querys for every company which is why i saw fit it
keep separate databases
 
with the infomation in the table and the way i have
everything set up i would have to create 1 form 5 tables
and 5 querys for every company which is why i saw fit it
keep separate databases
Click to expand...

I think what Vanderghast is saying - and I agree with him - is that
the way you have the database set up IS WRONG, and should be changed.
If you have all the information in *one single* table, you can create
a Query to select the information for a given company; you'll get the
"look" of a table with just that company's information.

If you insist on using an incorrect database structure, yes - it's
going to be a lot more difficult. If you work with Access instead of
struggling against it, you'll find it works very well.
 
Back
Top