Data Changed/Missing

[mewins]

I am trying to figure out if my database has become corrupted or if users are
accidentally changing/writing over data and not admitting it. I have a large
client database with a front end and back end. I am getting reports that
client names (separated by first middle and last) are appearing either
misspelled or altered completely. Due to the nature of the database and
work, making those fields read-only isn't really an option. Is there any
good way to figure out if the names are actually being changed by staff or if
the data has become corrupted somehow?

Thanks!

 

[Jeff Boyce]

One approach might be to add in LastUpdated and UpdatedBy fields in that
table, then add in code that sets these to the current date/time and the
PC's user, respectively.

NOTE: you'd add in this latter feature via a form, so anyone directly
changing the table still wouldn't show.

NOTE2: if your back-end/data is being stored in something like SQL-Server,
there should be a log of those changes.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

If it is data entry errors then why not have a separate table for the names
and use a list box to select the name rather than typing?

 

[mewins]

I may just do that. And the back end is in Access 2003, just like the front
end. I'd love to upgrade to something else someday, but no budget for it.

 

[mewins]

Staff to generally pick client names from a drop down list, but for other
purposes, we have the names on a tab and one can then add/edit them. I have
to allow staff to add/edit client names for the work we do, but I would like
to figure out if the sudden name changes are due to staff error or if my data
is somehow getting switched around.

 

[Jeff Boyce]

You can restrict a combobox to the items listed (LimitToList = Yes), but
still provide a method for adding new items (NotInList event). Check Access
HELP re: NotInList

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[mewins]

I will have to try that out. Thanks!

You can restrict a combobox to the items listed (LimitToList = Yes), but
still provide a method for adding new items (NotInList event). Check Access
HELP re: NotInList

Regards

Jeff Boyce
Microsoft Office/Access MVP