Determine File Name

[rbehnke]

I provide an .mde file for use by several company personnel to help communicate progress on a project. They copy the .mde to their desktop and access a separate Access back end file for the data.

I am using Access 2007, but have not converted the file from Aceess 2003.

I do updates periodically to the master .mde file and would like to tell Users when they access their file that there is a newer file available, with newer updated features, etc.

I thought I would reference the file name and compare the version number I apply to each new .mde file to see if it is current with a version number I update in a table when I do the update. BUT, I don't know how to reference the file name of the front end file that they are opening from their desktop.

Can someone help with that simple code?

Thanks for the help.

 

[dhookom]

Have you considered a couple "version" tables in the front-end and back-end files? You could compare the version number in the MDE with the updated version number in the back-end to see if they are the same.

Duane
Hook'D on Access
MS Access MVP

 

[rbehnke]

Excellent SIMPLE idea . . . hadn't thought of it that way cause I don't normally put tales in the .mde file. But I sure could.

Thank you . . .thank you.

Most Apreciated!!!

 

[MichaelRed]

Not actually relevant to your inquiry, but something to consider in managing your apps.

I kept track of the usage of the forms and reports in the BE of database apps. It was initally a tool to aid in the upgrade / conversion of a large app. I wanted to avoid updating features / functions which were not used, and at least discuss items with a very low usage.

In a more direct response, I have just used the file date time stamp on the local / server versions of the front ends, and automatically copying the new FE to the local system when the server version is 'newer' than the local one. The version number may be more professional, it is also prone to the human error of forgetfullness.



MichaelRed