Transaction Databases

WARNING:  THIS OPERATION IS FOR ADVANCED USERS ONLY !

The purpose of creating a Transaction Database is to store transactions independent of the Job database so as to improve access times and reduce activity in the Job database. This is often important if you are using large  Microsoft Access databases. By splitting your existing job database effectively in two improves speed and stability.

Steps:

1. Back up the System and Job database for the Company in question

2. Ensure that everyone across the network has DBW32 closed

3. Go into the Audit Trail and note down the amount of transactions in the system and also the last transaction number recorded

4. Go to Setup, select the Company you want to create a Transaction Database for, and click the white page to the right of the Transaction Database box.  Navigate through the explorer screen to the location of the current job and system databases.  If your job and system databases are called DBWjob & DBWsys, use the same naming convention, e.g.  Dbwtrans.  Type the name in the file name box and click Open.  The system should respond that the database is created.  Exit out of DBW32.

5. Run DBW32 and go to Setup.  Click on the Databases tab.  Click the yellow open folder and select your JOB database.  Highlight the transaction table on the right-hand side, then click the Copy Database Tables icon on the toolbar.  Navigate through the explorer screen and select the Transaction database you have just created and click Open.  It will say, transactions already exits, do you want to delete it?  Click Yes.  The program should start copying all the transactions from the Job database into the Transaction database.  Wait until a message box appears, then click ok.

6. On completion, go back to the Companies tab and make sure that the Transaction database is nominated for the correct company.  Go back to the logon screen and go into the company and check the audit trail to ensure that all transactions have copied successfully.  (Compare the amount of transactions and transaction number with the details you noted down earlier).  If this is ok, exit databuild.

7. Open DBW32, go to setup, click on the databases tab.  Click the yellow open folder and select your JOB database.  Highlight the transactions table on the right, then highlight ALL the records down the bottom half of the screen and hit the trash can.  Go back into the company and check the audit trail once more.

The exercise is now complete resulting in a new transaction database containing all of the existing transactions and the transactions removed from the Job database.

*** EXTREMELY IMPORTANT NOTE ***

MAKE SURE EVERY COMPUTER IN THE OFFICE HAS THE NEW TRANSACTION DATABASE NOMINATED IN SETUP AGAINST THE CORRECT COMPANY AT ALL TIMES.  OTHERWISE SOME USERS WILL BE POSTING TO THE JOB DATABASE AND SOME TO THE TRANSACTION DATABASE.

.