Access Form Modified date changes when nothing is changed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

With Access 2000, can someone tell me why my "Modified" date is changing when
I don't make any changes to the form? This is that I did: I opened a form,
opened the code behind the form and then proceeded to close the form.
However, when I look at the "Modified" date of the form, it has changed to
the time that I closed the form. However, I did not make any changes to the
form, because when I closed it, Access did not prompt me to save the form.
 
Tony_VBACoder said:
With Access 2000, can someone tell me why my "Modified" date is changing when
I don't make any changes to the form? This is that I did: I opened a form,
opened the code behind the form and then proceeded to close the form.
However, when I look at the "Modified" date of the form, it has changed to
the time that I closed the form. However, I did not make any changes to the
form, because when I closed it, Access did not prompt me to save the form.
Click to expand...

An Access file is "modified" just by opening it. You wouldn't even have needed
to open your form at all.
 
I think you misunderstood my question. Not the MDB file date/time stamp is
changing, but a Form object within Access. I am well aware of when you open
an MDB file, the date/time stamp changes.
 
Tony_VBACoder said:
I think you misunderstood my question. Not the MDB file date/time stamp is
changing, but a Form object within Access. I am well aware of when you open
an MDB file, the date/time stamp changes.
Click to expand...

In Access 97 each database object was stored in an individual BLOB record
of a system table. In Access 2000 and newer the entire project is a single
BLOB entry. I suspect that the object modified date now mimics the project
modified date as a result of that change.
 
No...I am able to open other forms and close them without the date/time
changing on the form object itself.
 
Tony_VBACoder said:
No...I am able to open other forms and close them without the
date/time changing on the form object itself.
Click to expand...

Does the form have a statement like

DoCmd.Save

in its Load, Current, Unload, or Close events?
 
Back
Top