Perhaps the records are not gone... are you using a query to display
them? If so, perhaps they are simply not showing. Are you comparing
the number of records in each TABLE to what you used to have?
although this information won't help you now, it is something that would
be highly useful to add to anything else you develop or work with in the
future so you can do better comparisons:
*** Tracking date record was created or updated ***
Add these 2 fields to all your tables (except lookups) and make them the
last 2 fields.
DateCreate, date, DefaultValue = Now()
DateUpdate, date – set on the form BeforeUpdate event
the best way to use the DateCreate field is to set a default value of
=Now()
in the table design.
For DateUpdate, make sure it is on your form (I put it in the form
footer and LOCK it. Then, use the Form BeforeUpdate event to set the value
me. DateUpdate = now()
'~~~~~~~~~~~~~~~~
another thing to do is to compare what is common with the missing
records by linking to a backup of the table in your database and using
queries to compare them
'~~~~~~~~~ Decompile ~~~~~~~~~
if the database has gotten corrupted, try decompiling the database
make an icon with this as its target:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\path\filename.mdb" /decompile
if your Access program is not located in the directory specified, make
the appropriate substitution
after you decompile, compile it if you have any code and then do
compact/repair
'~~~~~~~~~ ~~~~~~~~
you can also make a "generic" decompile icon where the next database you
open will be decomipled...
ie:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /decompile
Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
