Hi guys
Have been using Access for many many years (basic level) at work
Our POS was designed in Access and all our database is in our MDB file
Long story short, over the years the business has changed and we now have 4 different MDB files for each store (all set up structurally the same)
It basically works by using the POS File.MDB file which is a small program that connects to ShopData.mdb and we are able to add new customers/and do everything we need to for the business)
Sample Tables
T_Customer
T_Stock
T_Transactions
etc
However to access the backdoor of the data we press F11 and create queries
I now get sent ShopData from each shop every night and then download and rename them to each shop name as below:
Sample Databases
Shop1.mdb (Emailed to me named ShopData.mdb)
Shop2.mdb (Emailed to me named ShopData.mdb)
Shop3.mdb (Emailed to me named ShopData.mdb)
Shop4.mdb (Emailed to me named ShopData.mdb)
To access each database I need to paste the new ShopData.mdb into the root folder of the POS File.MDB and open it.
Then to access another shop , I just rename or delete the ShopData.mdb to something else and copy another shops data
Very messy - What I am wanting to do is make a query inside all 4 shops linking T_Stock
Is something like this possible ?