Splitting Application

[Guest]

How do I split an application into data (tables) and application
(queries,forms, and reports) and link them together. Please let me know.

 

[Guest]

I google searched and found this helpful article.

http://support.microsoft.com/?kbid=304932

 

[Winter Special]

Tools/Database Utilities/Database Splitter

 

[Guest]

Hi David,
Thanks for the link. I have read the article and this is just what I needed.
However, it put another thought in my head. Regarding the data (tables), my
application would be ideal if I could have a seperate back-end database for
each customer, as each project is short term, then the data for that customer
is not required. Also sometimes after the project is created for a customer,
the sale goes sour and the information for that customer is again not
required. Could I create a "template" database, copy and rename it
appropriately for each customer, then use the File->Get External Data->Import
functionality to switch between databases (customers), or is it really not
meant for constant use and might corrupt things. Please let me know. Thanks!
-Howard

 

[Guest]

Howard,
You and I have the same question. Hopefully we will both get the answer
with my post titled re-assign path of linked tables via code, just before
your original post.