Access 2003 Backend on shared network drive.

[Bosch]

Hi all...

I have an ACCESS 2003 application with front end in the local machine and backend on the shared network drive. I mapped this drive to E:\ in my computer and all my linked tables show the E:\folername\Databasename.mdb as the source.

When I install this application in an other computer where they have mapped the same drive to F:\ , I am getting error that says "E:\foldername\Databasename.mdb" not found. How can use absolute network drive(like \\cscrd\team\foldername\databasename.mdb) name to link the tables?

Thanks in advance.

 

[KenHigg]

You can find and change this in one of the hidden system tables...

 

[RuralGuy]

Going through My Network Places with the Linked Table Manager will use a UNC address.

 

[KenHigg]

Going through My Network Places with the Linked Table Manager will use a UNC address.

Hum... Never thought of that - Thanks!

 

[RuralGuy]

Any time Ken! I learn something new here almost every day.

 

[ghudson]

You can always type [copy and paste] the UNC string "\\cscrd\team\foldername\" into the "File Name" field of the dialog box when you are relinking your tables. When you click the Open button, it will then display all of the mdb files in that directory for which to choose the db you want to link the table to.

RuralGuy's click and browse suggestion is always a safe bet if the network shares are visable for you.

The UNC is the best way to go to avoid fixed drive mapping issues.

 

[KenHigg]

It would be nice if you could do relative file location like when using web sites. You know, like '..\..\foldername\filename.gif'. (I'm assuming this isn't possible..(?))