I probably should have asked this question before now but better late than never. Recently, I got a coding error that completly locked me up. I had to do a hard reboot. When I reopened my db every line of code in the db was gone. Fortunately, so I thought I had backed up the db. So I opened the backup and proceeded from there but it didn't seem right. I would compile code then save a form. When I reopened the form the code would be gone. Or my event coding would keep disappearing from the property setting. I was afraid I had trashed Access and would have to reinstall. Before I did that I started the db from scratch and built the first few rables from scratch. I didn't have any any problems. After that I started importing my tables, forms, querys, etc. So far I have had no problems but before I get too far I thought I should ask. Given the problems I described is it a mistake to import from my backup? Should I bite the bullet and rebuild everything from scratch?
VBA Error
- Thread starter Gilrucht
- Start date
R
Rich
Guest
Have you tried just importing everything into a blank new db?
thats what Im doing Im doing it table by table. So far the only problem I have had is with the form I was working with on when it crashed. I had to create a new one. Other than that everything I import works fine. My question is even though I have had no problems so far am I likely to have problems down the road. As much as I don't want to I'd rather start over now than get all done and find out I have a fatal error.
I spoke too soon. Earlier today I put calendar controls on the form bound to the table I was working on when I crashed and coded them. The code was working perfectly. I saved the form. I just reopened it and now I get an error message when I try to fire the event for either calendar. So far I am only going errors on this form. I have imported about 10 other tables and forms and have had no problems. Do I delete this one table and rebuild it then continue to import the others and hope for the best or do I bite the bullet and start the db over from scratch?
Thanks, RV. I'll do that. I think just to be safe I'll delete the table that form is bound to as well. What confuses and concerns me is why the form in the backup would be corrupt. Somehow Access corrupted all forms with that name when I locked up even though they were in different dbs. That makes no sense to me.
RV or anyone else,
I think I have a serious problem. When I went to delete the tables I got a message telling me "the OLE server may not be registered. To register the Ole server reinstall it." Does that mean I have to reinstall Access?
I think I have a serious problem. When I went to delete the tables I got a message telling me "the OLE server may not be registered. To register the Ole server reinstall it." Does that mean I have to reinstall Access?
