Dec 01, 2021
In Programming with CAIT
This of course can be time job title email list consuming and you may get away with not having to create the form again. It may also be worth moving just the objects you suspect work fine. Test the new database to make sure all is ok. Then bring across the item you suspect is corrupted. If the job title email list new database performs unexpectedly suddenly then you know which object caused this and it may then be worth taking the decision to recreate that object. Another classic job title email list scenario is when a user does not close the database properly. Sometimes when a user wants to get out of the office dead on time it can be tempting to job title email list just press the shut down button on the pc without closing the Access database and logging out of Windows. Again, this makes the database prone to corruption. Power failures and problems in a multi user environment job title email list are other causes of database corruption. It is always worth job title email list compacting the database. This is an option within Access and is called 'Compact and Repair'. When data is removed from a database Access removes the record, but not the space it occupied. Compacting the database resolves this.If Access is unable to job title email list perform the compact and repair it will show an error message, otherwise it will simply go ahead and do it without displaying any message. Once completed your database will be loaded.Always keep a backup copy of the database so that you can refer to the copy should anything go wrong. It is worth investing in backup software and some job title email list of it is even given away free on magazine CD's.