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?

In news:1182280047.293610.140960@o11g2000prd.googlegroups.com,
Access Freak <fakethingsster@gmail.com> wrote:
> 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 MVP
www.datagnostics.com

(please reply to the newsgroup)

On Jun 19, 9:16 am, "Dirk Goldgar" <d...@NOdataSPAMgnostics.com>
wrote:
> Innews:1182280047.293610.140960@o11g2000prd.googlegroups.com,
>
> Access Freak <fakethingss...@gmail.com> wrote:
> > 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!