In my asp.net webpage I am loading data from an .accdb MS Access database that has tables that are linked to another .mdb database.
My website works fine on my own dev machine.
When I upload it to the webserver, the path to the linked database becomes incorrect. This is because Access only lets you use the Linked-Table Manager to assign full paths, and I had to use full paths to locations on my dev machine.
On my webserver, I have Visual Studio Web Express 2012, but not MS Access. How can I change the paths in the linked tables? Can I do this with Visual Studio, or is my only solution a coded one?
Well, this is a workaround.
I ended up moving the dev-db to the same network location as the production db. That way I can use it on my dev machine and in production and just change the path before uploading the accdb containing the linked tables. The paths exist in both places already.
Not really the solution I wanted, but it works just fine.
There are some coded solutions, too, that I've found.