Directory Paths 1

[Chris1977]

Hi there,

I'll start out by outlining the directory structure we currently have the database stored in. On the network there is a drive mapped as G. On this drive we created a folder called SupDB. Within that folder we have a file called supdbdata.mdb that just houses the tables and relationships for the database. There is also a folder in G:\SupDB called build which contains a file called supdb.mdb. This file contains the coding forms etc. as well as the linked tables from the supdbdata.mdb.

Everything was working fine until it came time to test on another computer. This is when we learned that the drive maped as G: on our PC is really just mapped to a shared folder and not the root. As a result, when we try to run the database on the 2nd PC Access is unable to find the files it wants because it is looking in G:\SupDB and not G:\sharedfolder\SubDB.

With that said my question is this. Where does Access store the directory paths? At no point did we specify the G drive or directory paths but access seems to have assumed as much since that is the drive we were building on. Can this be changed with Access without remapping the drives?

Any thoughts or workarounds will be greatly appreciated.

 

[Rick39]

They're stoted in MySysObjects table (system table).....see thread181-395643 for a possible work around (UNC)

 

[Chris1977]

Thanks, I think this will help. However, I may just be having a bad day with this headcold and all but is there any reason why I may not be able to see the MySyObjects folder? I could swear I saw those tables there last week.

Perhaps it is the .mdw file I am connected to or maybe it is something the IT guys did when they were down and messing with drive permissions.

Thanks again for the help.

 

[Rick39]

You have to go to Tools->Options->View tab and select Show System Objects

 

[Chris1977]

Other than code is there any other way of modifying the MSysObjects table?

Thanks