I'm not on a network. My tables fields are all plain text, except 3 are hyperlink fields. I have a customized split form, though which most inputting is done. I use the datasheet view to check and edit. I have someone send me records sometimes, but they have been simply copied from her database and then I paste them into mine. No one else uses my computer.
I do not have any macros.
About a week ago, about 10% of my records disappeared after making and running a simple query to show them, sorted by one filed. Nothing I have tried has found them.
I have a backup of that file, but it would take a couple days of tedious editing to bring it up to date.
I've just made a backup of the file that the records disappeared from and would like to copy and paste a few hundred records from the older backup, to help bring it up to date, thus cutting out some of the tedious re-editing.
But when I open the new backup, I get the "SECURITY WARNING. Some Active content has been disabled." Previously, I would have ignored the warning and set the table not to show warnings, because I know where the contents came from. However, given the disaster a week ago, the warning makes me nervous. When I check Run Macro, no macros show up, which is at it should be, as I have none.
Given the above, should I simply turn off the warning, or should I be worried?