
Signature
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
>> I've noticed that you can use an app for a
>> few minutes and exit without changing the date/time.
>
>I don't think that's true, if you have it open in the UI. Of course,
>assuming a front end/back end structure, it would be only the front
>end that would get the date updated.
That's not been my experience but I haven't done any serious reviewing
of that so I could be wrong.
>The back end's date changes
>only if you view a table.
Could be.
Tony

Signature
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
>> I've noticed that you can use an app for a
>> few minutes and exit without changing the date/time.
>
>I don't think that's true, if you have it open in the UI.
I just tried this on a non split app. The date/time of the file
didn't change until I opened a second filtered form.
>Of course,
>assuming a front end/back end structure, it would be only the front
>end that would get the date updated.
On one app I just tried it did change the FE date/time but the only
operation done was that particular app automatically relinks the
tables.
>The back end's date changes
>only if you view a table.
Nope, I just opened a form against a table and then the linked table
directly without changing any data. The BE date did not change.
Tony

Signature
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
David W. Fenton - 21 Jan 2008 23:00 GMT
>>> I've noticed that you can use an app for a
>>> few minutes and exit without changing the date/time.
[quoted text clipped - 3 lines]
> I just tried this on a non split app. The date/time of the file
> didn't change until I opened a second filtered form.
I just tried it on a split database. If I open the MDB and open no
objects, the date doesn't change. If I open even one object
(including a linked table), the date changes.
>>Of course,
>>assuming a front end/back end structure, it would be only the
[quoted text clipped - 3 lines]
> only operation done was that particular app automatically relinks
> the tables.
Seems to me that any operation that changes the objects in the front
end will change the date. Opening a linked table may update some of
the metadata stored in the table link, while opening forms/reports
changes something or other (maybe -- I didn't try it; might also
depend on whether or not the form has a recordsource or not).

Signature
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Tony Toews [MVP] - 22 Jan 2008 02:40 GMT
>> I just tried this on a non split app. The date/time of the file
>> didn't change until I opened a second filtered form.
>
>I just tried it on a split database. If I open the MDB and open no
>objects, the date doesn't change. If I open even one object
>(including a linked table), the date changes.
Then our experience differs.
Tony

Signature
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
David W. Fenton - 22 Jan 2008 22:43 GMT
>>> I just tried this on a non split app. The date/time of the
>>> file didn't change until I opened a second filtered form.
[quoted text clipped - 4 lines]
>
> Then our experience differs.
Well, I tried it in A97 and A2K3. Maybe you're using a different
version?

Signature
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Tony Toews [MVP] - 28 Jan 2008 05:18 GMT
>>>> I just tried this on a non split app. The date/time of the
>>>> file didn't change until I opened a second filtered form.
[quoted text clipped - 7 lines]
>Well, I tried it in A97 and A2K3. Maybe you're using a different
>version?
I'm pretty sure I would've used A2003.
Tony

Signature
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/