Split the Access DB in to 2 sections because had gone over 1GB limit on customer site. Simply create a second file with same database name "_2.mdb". The second file contains all Transactions records.

Note: when first run BOTH data files must be a copy BLANKDATA.MDB

MS SQL : 19/7/2005 File V3 V5.6.9 for Enterprise V5.61.001

Added Trim(.stBinLocation) since Exchequer had changed the COM Toolkit

MS Access : 19/7/2005 File V3 V2.1.20 for Enterprise V5.6.002

Added Trim(.stBinLocation) since Exchequer had changed the COM Toolkit

MS SQL : 13/6/2005 File V3 V5.6.7 for Enterprise V5.61.001

Now uses the ADO instead of the DAO to update SQL Server. Lots faster

MS Access : 10/3/2005 File V3 V5.6.0 for Enterprise V5.6.002

Improved speed of update

Now gets the Auto Daybook data without ODBC

MS Access : 10/3/2005 File V3 V2.1.17 for Enterprise V5.6.002

Now gets the Auto Daybook data without ODBC

MS SQL : 15/12/2004 File V3 V5.6.0 for Enterprise

Version for MS SQL Version

MS Access : 12/12/2004 File V3 V2.1.5 for Enterprise V5.6

Alterations for MS SQL Version

MS Access : 10/6/2004 File v3 V2.1.3 for Enterprise V5.6

Works with up to 15 Companies for KLB

Also stopped if stock record was corrupted, made skip.

MS Access : 21/3/2004 File v3 V2.1.0 for Enterprise V5.6

Many new Fields added:

TranHeader Table:
    Taken out THNotes

Added:
    THGenNotes (General Notes)
    THDatNotes (Dated Notes)

TransLines Table:
    TLVATIncValue
    TLB2BLineNo
    TLB2BLinkFolio
    TLCOSDailyRate
    TLCISRateCode
    TLCostApport
    TLUseQtyMul

Stock Table:
    STWORQtyAlloc
    STWORQtyPicked
    STWORQtyIssued
    STWOPMinEconBuild
    STWOPAssemblyDays
    STWOPAssemblyMins
    STWOPAssemblyHours
    STBOMProductionTime
    STWOPAutoCalcTime
    STWOPRoLeadTime
    STWOPIssuedWIPGL
    STUsesBins
    STShowKitOnSales
    STDatNotes (Dated Notes, STNotes has General Notes)

Account Table:
    CSDATNotes (Dated Notes, CSNotes has General Notes)

MS Access : 27/2/2004 Version released for Exchequer 5.52

MS Access : 23/12/2002 1.0.0 Beta released for testing

More Information about Exchequer Software

[ Home ] [ Up ] [ More about Exchequer Software ] [ IRIS Enterprise Software ] [ WebRangle Linking ]

Last modified: January 31, 2008