Lost macros and forms...happened right after zipping

[jeffrowles]

Help...I have a project (in MS-Access 2003) that has a form and corresponding
macros that I have spent the better part of the day developing and was saving
locally on my hard drive. I zipped the file this evening so I could e-mail
it to someone. When I went back to open the original file, it just opened
blank without any tables, queries, forms or macros...I tried to compact &
repair and this did nothing. Then I opened the file using using MS-Access
2007 and at least it opened this time but my forms and macros have completley
disappeared.

I have tried to restore from a shadow copy of about 11:30 this morning in an
attempt to at least get something back and it does the same thing....just
shows me a blank Access screeen without opening anything?

Not sure if it makes a difference, but I have Access 2003 and 2007 both
loaded on my laptop...also, I had an "Autoexec" macro that automatically
opened the form that I lost.

I would really really appreciate it if anyone has any ideas of how to
recover...I have spent so much time on this project.

Thanks, Jeff

 

[Larry Linson]

I do not know the cause of your macros and forms disappearing, but that is
certainly neither a "standard feature" nor is it a "common occurrence" in
Access 2003. I can't imagine why ZIPping a file would cause this to happen,
because every ZIP program of which I am aware only READS the original file,
and does not write to it.

I hope that you have seen, and heeded, the admonitions here to make frequent
backup copies... my personal rule is that I make backup copies frequently
enough that I will not have a great deal of information to re-type (and, if
developing, re-test also).

Larry Linson
Microsoft Office Access MVP