find file name

[Brambojr]

I am working on a project where we will have one back end file and mulitple front end files (one for each department). These front end files will be replicated with one replica going on each computer. The OS's don't share well and it will save network resources, so this appears to be the only workable solution.

Ok, so some of our users are just savvy enough to be annoying/dangerous and I'd like to make resilient code.

I want to be able to find out the file name (in the system) of the database they are in. They will, at times, have more than one file open at a time.

Is there a solid way of doing this? I am tempted to just declare the file name in code, but I know a few may rename the file(s) and I need accuracy in this.

Help???

Brambojr

 

[Steve101]

The CurrentProject.FullName object/property pair will provide you the fully qualified filename of the database that you are in.


Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[Brambojr]

This worked perfectly. I just plugged in some code to whittle it down to only the file name and well, this is exactly what I wanted.

Thanks Steve101.

Brambojr