I have an access application that uses a sql server express database. The application works well but i am wanting to have it work with a localdb or a sql server express
When the application is open i will read the ini file to determine what database it will use,
Right now i have all the tables as linked tables to the sql server database, i would like to be able to have each of those tables re-mapped to the localdb with an attachedbfile= and the path of the localDB.
If it is run and the sql server is chosen it would remap those linked tables using an dnsless connection to the sql server.
Is this possible. I have some code that remaps the sql server part to a new DSN and it seems to work ok, but i can't seem to modify it to get it to work for a localdb