Hi, I would like to know if the following is possible and how:
I have several identical Access backend databases (one for each client, same scheme - different data, several relationships, links and foreign keys). I would like to merge all of them to one MS SQL database and add an identifier for each client data. One time only!
How to handle original relationships? Example: InvoiceID and InvoiceLine for each original database.
I’m talking about Access DB, but I could convert them all to MSSQL and then merge…
All front ends will connect to this database, but each client will be able to see only each own data.
Any help? Thanks!
Jairo