Almost without exception Access XP will corrupt the program database after a day of programming. I need to compact my database every half hour (or hour tops).Things get more and more sluggish (the database size grows extreme also btw) and then after a while it will just break down. Access crashes and my database is broken. In many cases even beyond repair or up to th epoint where I need to import everything in a new database (and then I have to put the security back on).
This is really incredibly annoying. I have installed every update for Office XP that I could find, but to no avail. I have been searching the internet for months how to fix this, but I have gound nothing besides the Microsoft knowledge base nonsense which basically claims that all corrupt databases are caused by faulty networks or faulty harddisks. I have used (and still use) Access 97 and I have never had this kind of mess.I thought only Access 95 was such a lemon (which suffered the same crashing and loss of work duu to databse corruption)
I bought a whole new computer to try and fix this. Again no luck. It still crashes. I tried editing the forms/VB on the local disk or on a network drive. That made no difference either.
Oddly enough I have no problems at all with the data database (containing the tables) going corrupt. It's only when I'm editing the database containing the forms and VB that the whole lot bloats out of control and then after a few hours crashes.
Personally I think it has to do with use of the VB editor or with compiling or not compiling things. When I program in VB I have more problems (or at least they appear to cause problems quicker)
I assume the two problems are related:
1) exploding program database filesize
2) corruption of the program database file
Please, please, please help me get rid of this.