access altering data?

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

Guest

i ahve a database for 'contributors', the db includes such things as 'paid
to' date feild etc....
suddenly after 6 months, the database is changing some 'paid to' dates to
2005, or more commonly december o5 when the database wasnt even
operational?....

i just dont understand how this could be happening?

any help would be appreciated
 
i ahve a database for 'contributors', the db includes such things as 'paid
to' date feild etc....
suddenly after 6 months, the database is changing some 'paid to' dates to
2005, or more commonly december o5 when the database wasnt even
operational?....

i just dont understand how this could be happening?

any help would be appreciated
Click to expand...

Without knowing anything about your tables or forms or anything else
about the database, it's hard to say; but I've certainly never seen
Access just go in and edit data on its own!

Where are you seeing this change? On a Form, in a Query, directly in
the Table?

Do you have these records open for editing for some other reason?
Might the dates be getting reset, manually or programatically?

John W. Vinson[MVP]
 
The data shows up on each contributors 'details' form and when i view the
table for same...the data is changed there also. "Apparently' the records are
not open for editing, its just something that was literally stumbled accros
and was noticed becayse some of the altered dates go back to 2005 when the
database wasnt even in operation?....
 
The data shows up on each contributors 'details' form and when i view the
table for same...the data is changed there also. "Apparently' the records are
not open for editing, its just something that was literally stumbled accros
and was noticed becayse some of the altered dates go back to 2005 when the
database wasnt even in operation?....
Click to expand...

Sorry - I simply don't know what could have happened other than that
someone edited the data. And I don't think it will be possible to find
out when or how the data was altered, since Access doesn't track
changes.

I've seen date fields messed up (usually more drastically, such as
putting records into 2024 or the like) when a hasty user enters a day
into the year portion of a mm/dd/yy date format.

John W. Vinson[MVP]
 
Back
Top