Free E-Books

You can then open your database, open any
module, and select Debug ??? Compile projectname where projectname is simply the name of your
project (original database filename). After the database compiles, you should close the module,
return to the Access window, and compact and repair the database. You should find that Access
runs these procedures much faster than usual.
Make sure that you immediately exit Access 2007 after it finishes decompiling and then
start Access again before running Compile projectname or Compact and Repair Database.
Recapping the six steps to large database success
If you??™re ready to release your application for a real test by the users, you should follow the steps
below to insure a clean-running system:
1. Reboot your computer to clean up memory.
2. Create a new Access database and import all the objects. Then close Access.
3. Restart Access by using the /decompile option while holding down the Shift key.
Close Access after the database window is displayed.


Pages:
1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639