0

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?

bgmCoder
  • 6,205
  • 8
  • 58
  • 105
  • Can you temporarily simulate the production path on the dev machine, and then make the links correct before uploading it? Also, you can link tables dynamically with VBA code - which would be runnable from a macro on the production machine with the free Access Runtime. – mellamokb Jun 17 '14 at 01:26
  • Yes, by editing the host file, I'm sure. I did try using an admin's unc share - except for permission problems. I wish I could just edit the file somehow after copying it. – bgmCoder Jun 17 '14 at 01:27

1 Answers1

1

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.

Community
  • 1
  • 1
bgmCoder
  • 6,205
  • 8
  • 58
  • 105