Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

Why does viewing a MDB file change the modified date?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Randy K - 16 Jan 2008 01:32 GMT
This has probably been asked many times before but I haven't come up
with anything on google.  Why does opening/viewing a MDB file change
the modified date?    This implications as far as our backup stratgey
goes.

Thanks.
John W. Vinson - 16 Jan 2008 02:33 GMT
>This has probably been asked many times before but I haven't come up
>with anything on google.  Why does opening/viewing a MDB file change
>the modified date?    This implications as far as our backup stratgey
>goes.
>
>Thanks.

The detailed "why" would require inside information as to the workings of
Access, but it's routine behavior. Access must keep track of... something...
user security, query stats, who knows what!

If you need to keep track of when data in your tables is updated, Access won't
help you; it neither tracks nor exposes that information. You'll need to track
it yourself, not an easy task unfortunately!

            John W. Vinson [MVP]
David W. Fenton - 20 Jan 2008 23:06 GMT
> The detailed "why" would require inside information as to the
> workings of Access, but it's routine behavior. Access must keep
> track of... something... user security, query stats, who knows
> what!

Well, we do know at least one bit that needs to be written to, and
that's the SUSPECT flag that is set to OFF when the database is
successfully closed by Jet. I assume it's set to ON when the
database is opened and thus, when there's a bad shutdown, you are
prompted to compact/repair.

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

Tony Toews [MVP] - 21 Jan 2008 01:36 GMT
>Well, we do know at least one bit that needs to be written to, and
>that's the SUSPECT flag that is set to OFF when the database is
>successfully closed by Jet. I assume it's set to ON when the
>database is opened and thus, when there's a bad shutdown, you are
>prompted to compact/repair.

I disagree.  I've had clients who have several times had a power
failure with about 15 - 20 users in the database.    Upon restoring
power they were able to continue using the system without doing
anything.   I was on site for those power failures.   The server was
on a UPS but not the client workstations.

That flag is momentarily set while doing updates or inserts.  Not when
you open the mdb..

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/

Tony Toews [MVP] - 16 Jan 2008 03:03 GMT
>This has probably been asked many times before but I haven't come up
>with anything on google.  Why does opening/viewing a MDB file change
>the modified date?    This implications as far as our backup stratgey
>goes.

I suspect Access is either changing the query statistics or possibly
changing the form filter.  I've noticed that you can use an app for a
few minutes and exit without changing the date/time.  But any more
specific I haven't bothered to do any research.

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 - 20 Jan 2008 23:07 GMT
> 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. The back end's date changes
only if you view a table.

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

Tony Toews [MVP] - 21 Jan 2008 01:37 GMT
>> 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/

Tony Toews [MVP] - 21 Jan 2008 01:42 GMT
>> 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/

Tom van Stiphout - 16 Jan 2008 03:42 GMT
It's just the way it is. The Access development team decided it was
the right thing to do.
Of course if you do a binary comparison of the file before and after a
simple Open (perhaps using fc.exe in a command window), you'll notice
that it has in fact changed. Perhaps some internal flags, perhaps a
new compilation state, we are not privy to those finer points.

So I would say if the Archive bit is set, better back it up.

-Tom.

>This has probably been asked many times before but I haven't come up
>with anything on google.  Why does opening/viewing a MDB file change
>the modified date?    This implications as far as our backup stratgey
>goes.
>
>Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.