Multi files

[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

 

[Michel Walsh]

Hi,


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


Vanderghast, Access MVP

 

[Guest]

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

 

[John Vinson]

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

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.