CurrentProject.Path in Access

[Access Freak]

I recently inherited an Access database that needs to refer to files
within the directory where the database is located. After viewing the
code, the modules use the CurrentProject.Path method/attribute to
determine where it's located.

The database was originally located in C:\Program Files\database\...
and has been recently moved to a share on the network \\myshare
\database\... The physical location on the remote computer is not in
the Program Files folder. However, CurrentProject.Path still returns
"C:\Program Files\database\...".

Does anyone know why this is and how I can remedy this situation?

 

[Dirk Goldgar]

In

I recently inherited an Access database that needs to refer to files
within the directory where the database is located. After viewing the
code, the modules use the CurrentProject.Path method/attribute to
determine where it's located.

The database was originally located in C:\Program Files\database\...
and has been recently moved to a share on the network \\myshare
\database\... The physical location on the remote computer is not in
the Program Files folder. However, CurrentProject.Path still returns
"C:\Program Files\database\...".

Does anyone know why this is and how I can remedy this situation?

I've never heard of this problem, and a quick test doesn't reproduce it
for me. Pardon what may be an obvious question, but are you sure you
aren't running a front-end/back-end application, with the front-end on
your C: drive?

What version of Access?

 

[Access Freak]

In




I've never heard of this problem, and a quick test doesn't reproduce it
for me. Pardon what may be an obvious question, but are you sure you
aren't running a front-end/back-end application, with the front-end on
your C: drive?

What version of Access?

Okay... I don't know what happened overnight but it started working
today. I'm not crazy; it wasn't working yesterday.


Sorry for the trouble but thanks for your help!