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]

Post by 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?

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]

Post by Dirk Goldgar

Post by 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?

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?
--
Dirk Goldgar, MS Access MVPwww.datagnostics.com
(please reply to the newsgroup)

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!