Determine File Location

[alex]

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

 

[Dirk Goldgar]

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).

 

[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