Linking Split Database Frontend with Multiple Backends

Question

I have an Access 2010 database I use to manage events for several clients. I want to split the database in such a way that each client has its own backend. The frontend would be the same for all clients, and the tables in the backend would be the same - just the data would be different. I need some help finding out 1) If this is good idea or if there is a better way to keep the data separated by client, 2) how to create the different backends with empty tables so I can add new data, and 3) how to change the links to the different backends from the frontend.

This is not a shared database. I am the only person who uses it - I just want to keep the data separate.

Thanks for your insights! J.

Answer 1

If you want to give the app to your client at some future date, then, when that future date comes, Create a new blank file. Then run Make Table queries for all your tables filtering for CustomerID to the new file.

What I would do is have an unbound combobox on your startup form to select the Customer you want to work on. Make sure you leave this form open all the time you can hide it but not close it.

Then all your forms should use queries as the Recordsource. The criteria for the CustomerID column should be:

=Forms!startupformname!cboCustomer

Then each form will open only for the customer you selected. Need to work on a different customer, then just change the selected customer.

Answer 2

They are either an auto rim with the spokes in a star pattern or a circular astrologic map of the stars.

Answer 3

Oh dear. If you tell me you know what star wheels are I'll be truly impressed. Thanks again for your help!

Answer 4

You can certainly use TempVars if you prefer. I go back to before Tempvars existed, so I tend to use the form reference method.