We suggest that you print this out now and keep it. Then when you have a problem you can refer to your printed copy of this page. If you don't find the answer on your printed copy of this page then go back and look at the page on the internet as we may have updated it since you printed it. If you can see that we HAVE updated it and that there is more useful information on the page then you may like to print it again to update your printed copy.

Before printing the page you might like to click on the VIEW menu and then TEXT SIZE and then SMALLEST in order to automatically reduce the number of printed pages that it takes to provide a hard copy of this page.
If you suspect that the database may be corrupt then you need to repair it which is a simple process. Symptoms of it being corrupt is that you get "Illegal Function Call" or "SQL Query Error" error messages or possibly that it tells you that there are no timesheets on file when you know that there are. The easiest way to repair it is to
  1. go into the Payroll
  2. Click on the DATABASE menu
    Import/Export Data
    SQL Execute Statements
    HTML Queries
    Install Program Update
    Update Data Definitions
    Network Program Update
    Initialise Misc Codes
    Export Structure
    Repair/Compact Database
    Repair using MS-Access V2
    Convert from Access V2 to V3 Database
    Convert Back to Access V2 Database
    Backup/Restore/Format Options
    Zip Up Current Database
    FTP Database to GO Software
    Initialise Payroll Data
    Convert Qantel Data
    Convert Rural Data
  3. Choose REPAIR/COMPACT DATABASE
  4. make sure that no-one else is using the payroll - click on YES
The payroll program will then show REPAIR DATABASE then COMPACT DATABASE down in the bottom left hand corner and then it will be finished.

Once you have done this, hopefully, your problem will have gone away. However if this hasn't fixed the problem them you can try to use MS-Access V2 to repair it.

Repairing Your Database using Microsoft Access V2

Top
If your database keeps getting corrupted even though your frequently repair it using the Payroll program then it may be that the repair is not working correctly. This appears to be a problem with Microsoft Access in that the repair function that we can call from the Payroll program doesn't seem to be as effective as the repair function actually called from Microsoft Access V2 itself. If you have a copy of Microsoft Access V2 (no other version will do) then you can use this to repair your database.

To repair the database using MsAccess V2 you need to follow this procedure....

  • Backup your current database (just in case)
  • Download and install the latest program update for Payroll if you haven't done it within the past month or so.
  • Determine where your database is located before you start - you can see this in the Payroll Program title bar at the top of the screen. For Payroll it should say something like G:\Payroll\Pay-Wea.MDB and if this was the case then the database is located in G:\Payroll folder and it is called Pay-Wea.MDB
  • Click on the DATABASE menu
    Import/Export Data
    SQL Execute Statements
    HTML Queries
    Install Program Update
    Update Data Definitions
    Network Program Update
    Initialise Misc Codes
    Export Structure
    Repair/Compact Database
    Repair using MS-Access V2
    Convert from Access V2 to V3 Database
    Convert Back to Access V2 Database
    Backup/Restore/Format Options
    Zip Up Current Database
    FTP Database to GO Software
    Initialise Payroll Data
    Convert Qantel Data
    Convert Rural Data
  • Select the option to Repair using MS-Access V2 and MS Access should start up
  • Select REPAIR DATABASE from the FILE menu
  • Locate the drive and folder in which the database is located - eg it may be G:\Payroll
  • Double click on your database file (the one ending in .MDB) - eg it may be Pay-Wea.Mdb
  • Wait for it to repair and tell you it's done
  • Then Select COMPACT DATABASE from the FILE menu
  • Locate the drive and folder in which the database is located - eg it may be G:\Payroll
  • Double click on your database file (the one ending in .MDB) - eg it may be Pay-Wea.Mdb
  • When it asks where to put the compacted file Double click on your database file again to overwrite the DB1.mdb entry - eg it may be Pay-Wea.Mdb
  • When it says that the file already exists - overwrite it Click on YES
  • Wait for it to compact (it says READY in the bottom line of the screen)
  • Then repeat both the repair and the compact operations again - just to make sure
  • Then go back and try the payroll again to see if that has fixed your problem.
Make sure that you are the ONLY person accessing the database when you do this - no one should be using the program or the database at the same time. Also, if you access the database though a network, it is best to do the repair and compact on the computer on which the database is located as it prevents network problems from causing any further hassles.