Record Deleted Error Message

[Guest]

Whenever I try to run a particular DB, I get an error message stating that
the record has been deleted. Can anyone tell me what Access is looking for
if nothing has been deleted?

Thanks

 

[Allen Browne]

If you get this message just by opening a table, it probably indicates a
corruption.

Try a compact/repair (Database Utilities on the Tools menu.)

If that doesn't fix it, see:
http://allenbrowne.com/ser-47.html#RowsShowDeleted

 

[Guest]

ajhome,

There could be code running on startup that is deleting, say, dummy records
used for backup in a previous session. Check the default Display Form/Page
for the application under Tools, Startup. Then load the Visual Basic Editor
(Alt-F11), select the form from the Project Explorer window, and see if any
code is running in the OnOpen or OnLoad event.

Check also for the presence of an AutoExec macro.

Hope that helps.
Sprinks

 

[Guest]

Greetings... Now I am getting an error message that states, not a valid
bookmark! Any ideas?

 

[Guest]

I agree with Allen. Try a Compact/Repair.

Sprinks

 

[Guest]

I do have an autoexec macro. What should I be looking for in that macro?