Hi,

Is it possible (in VBA) to check and see where an Access file is being
opened/accessed from?

For example:
If mdb/mde file attempting to be opened resides in C:\db then
'do something
else
'do something else
end if

Thanks,
alex

"alex" <(E-Mail Removed)> wrote in message
news:4f320ceb-c85f-41f7-b852-(E-Mail Removed)...
> Hi,
>
> Is it possible (in VBA) to check and see where an Access file is being
> opened/accessed from?
>
> For example:
> If mdb/mde file attempting to be opened resides in C:\db then
> 'do something
> else
> 'do something else
> end if
>
> Thanks,
> alex


CurrentProject.Path returns the folder path where the current database
resides.

CurrentProject.Name returns the name of the current database file.

CurrentProject.FullName returns the folder path and name of the current
database file.

CurrentDb.Name also returns the folder path and name of the current database
file, but doesn't work in an ADP (Access Data Project).

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

On Jan 13, 8:59*am, "Dirk Goldgar"
<d...@NOdataSPAMgnostics.com.invalid> wrote:
> "alex" <sql_...@yahoo.com> wrote in message
>
> news:4f320ceb-c85f-41f7-b852-(E-Mail Removed)...
>
> > Hi,
>
> > Is it possible (in VBA) to check and see where an Access file is being
> > opened/accessed from?
>
> > For example:
> > If mdb/mde file attempting to be opened resides in C:\db then
> > 'do something
> > else
> > 'do something else
> > end if
>
> > Thanks,
> > alex
>
> CurrentProject.Path returns the folder path where the current database
> resides.
>
> CurrentProject.Name returns the name of the current database file.
>
> CurrentProject.FullName returns the folder path and name of the current
> database file.
>
> CurrentDb.Name also returns the folder path and name of the current database
> file, but doesn't work in an ADP (Access Data Project).
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips:www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)

Worked perfectly Dirk; many thanks!
alex