CurrentProject.Path in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Access Freak - 19 Jun 2007 20:07 GMT

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?

Reply to this Message

Dirk Goldgar - 19 Jun 2007 20:16 GMT

> I recently inherited an Access database that needs to refer to files
> within the directory where the database is located. After viewing the
[quoted text clipped - 8 lines]
>
> 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?

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Access Freak - 20 Jun 2007 19:22 GMT

On Jun 19, 9:16 am, "Dirk Goldgar" <d...@NOdataSPAMgnostics.com>
wrote:

> Innews:1182280047.293610.140960@o11g2000prd.googlegroups.com,
>
[quoted text clipped - 22 lines]
>
> (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!

Reply to this Message