missing records

[Todd]

I've got an access 2003 dbase on a network and the dbase is split (FE / BE)
and is secured. There has been a couple of instances where after a user
enters their monthly data in the system and they print their reports, later
on the data they entered for that particular month has dissappeared. They've
got the printed reports showing that they did enter the data but the data is
nowhere to be found in the BE table. All the prior and subsequent months
information are there.

Has anyone had this happen before? If so, any suggestions? In case someone
did delete the information could someone tell me how to create a separate
table to store deleted records as a backup? At least by doing this it may
prove that it's a user issue instead of system mystery.

 

[ruralguy via AccessMonster.com]

Maybe an Audit Trail is in order here.
http://allenbrowne.com/AppAudit.html

 

[Steve]

Where do the reports get their data? Where do you open the report from? If
the report gets its data from the form and the report is opened from the
form, it is possible to enter data, print a report of the data and never
have the data get saved to the form's table. If something like this is
happening, I suggest you add the following code to the code that opens your
report but prior to the line that opens the report:
DoCmd.RunCommand acCmdSaveRecord

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)