Front end on shared drive, modified date?!

[redbull]

Alright quick scenario... I have a front end and back end, both on a shared drive.

90 users have shortcuts on their desktops, it is a vbs file. this vbs will copy down the front end if the date modified is newer on the front end, then the local copy.

So apparently my front end is showing date modified as of yesterday, this concerns me because I have not made any changes.

I guess I am wondering if this date modified would change for any reason other then someone opening the file directly off the shared drive and messing with it?



I know front ends and backends with vbs files are pretty common practice, so hoping someone has knowledge about this issue.

edit --

The front end is a MDE file, not MDB

[pbaldy]

The Windows modified date? That will change just by opening the file, so I wouldn't rely on it. There are probably many was to do this, but I use a local table in the front end, with fields for version number, date, and a brief description of the changes made. My utility compares the max version numbers in the local/server versions and copies down if different. An added benefit is it gives me a history of the changes made if I don't remember when I did something.

[redbull]

"That will change just by opening the file, so I wouldn't rely on it." - Hmm, but no one is supposed to be opening the front end on the server at all... thats what concerns me.


"There are probably many was to do this, but I use a local table in the front end, with fields for version number, date, and a brief description of the changes made. My utility compares the max version numbers in the local/server versions and copies down if different. An added benefit is it gives me a history of the changes made if I don't remember when I did something." - I will buy you a Klondike bar if you could help me do something like that, or point me in the right direction... That.. sounds...amazing.

[pbaldy]

Well, I use VB6 so I'm not sure if the syntax is different, but the relevant lines are:

  Dim rsAccess      As ADODB.Recordset
  Dim intServer     As Integer

  'get version number from server copy
  Set rsAccess = New ADODB.Recordset
  rsAccess.ActiveConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & g_sServerPath & ";Persist Security Info=False;"
  rsAccess.Open "SELECT Max(Version) AS MaxVersion FROM Version_local"
  intServer = rsAccess!MaxVersion

where g_sServerPath is the path to the file. I think my buddy Bill uses VBS and a text file:

http://www.thatlldoit.com/Pages/howt....aspx#feupdate