CurrentProject.Path in Access

A

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?
 
D

Dirk Goldgar

In
Access Freak said:
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?
Click to expand...

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?
 
A

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?
Click to expand...

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!
 
Top