Damn you VBA! :-(

[psbailey42]

Hi guys!

I'm in a bit of a sticky situation, I've been creating a database for the last 2 months with cracking results up until 20 minutes ago when my VBA modules decided to delete themselves!!!!!! aaagghhhh!!!

Everytime I try to access the VBA section of Access (2007-2010) it states "Error Accessing File. Network Connection May Have Been Lost." I now also cannot input anymore VBA without Access crashing.

Help would be more than welcome!

Cheers,

P,UK

[RuralGuy]

Try *importing* your db into a fresh new db and see if the problem follows: http://www.btabdevelopment.com/ts/impnew

[psbailey42]

It has let me important the tables but not the form used to input the information, this is also where the VBA is located?

[RuralGuy]

That usually indicates a corrupt form.
http://allenbrowne.com/ser-47.html
http://allenbrowne.com/recover.html
http://allenbrowne.com/ser-25.html