Changing modified date aon an .mde file

[mrees]

Dear Tipsters,

I am using Access2k as a front-end to a SQL2k database that is used by 25+ users. The way it was originally designed was that each users PC held a local copy of an mde file. When they log onto their machine, part of the login script would check the modify date of the mde file and compare it to the modify date on a copy held on a deployment server, changing them if the server version was newer.

I have had to make some changes to the front end, and now it seems that the modify date gets changed each time a user uses it - making the rollout procedure useless (the local version date is always after the server version date)

My question is what changes the modify date? Will the modify date change when someone populates forms etc?

Thanks

mrees

 

[lupins46]

Twas always so...
I'm afraid Access has never (well since 97 anyway, I can't remember what happened before that) worked the way you thought it did in this respect.

 

[mrees]

Lupins46,

Ah well, never mind. I think I'll have to plan my rollouts better - and make sure nobody uses the thing before they next log out/in

Thanks anyway.

mrees

 

[lupins46]

Since you already have the basic logic there, i would have thought it was a minor change to look at a date stored in the database itself.

 

[mrees]

It does seem to be the best idea. Thanks for your suggestion.

mrees

 

[Reuel]

I was using a similar concept, except I used a version number to determine which was newer.