Download Latest Version SetupAxBase_1.1.0.0.exe (652.4 kB)
    Email in envelope

    Get an email when there's a new version of AxBase

    Home
    Name Modified Size InfoDownloads / Week
    AxBase 2013-03-07
    ReadMe.txt 2012-01-04 1.9 kB
    Totals: 2 Items   1.9 kB 0
    =General :
     AxBase is an Open source MDB / SQL Server Database viewer and editor. 
     You can view & edit the tables (+ field descriptions) and execute SQL queries without Access licence. 
     Export Tables to CSV/ XLS, Compress & Repair MDB. Compile needs Delphi Pro.
     Compatible with Delphi 7 to Xe2 (pro).
    
    =Version History :
     1.1.0.0 : XE2 (and 2010/XE) compatibility & Suppress JCL/JVCL
     1.0.0.9 : Add trace for batch execution.
             : - Fix 'index error' message opening empty base.
     1.0.0.8 : Inline parameters for batch files
     1.0.0.7 : password for mdb files
     1.0.0.6 : add list of last queries + navigator
     1.0.0.5 : bug fixes.
     1.0.0.4 : add Table Navigator & change some file extension principes when save.
     1.0.0.3 : add 'delete table' & 'Open Xls Files' functions
     1.0.0.2 : bug fix for DBGRID 'error' on non SELECT (UPDATE/INSERT...) Query
     1.0.0.1 : add tools : export CSV & XLS
     1.0.0.0 : first release.
    
    =Command line :
     Since ver. 1.0.0.8 Axbase may be used with command line option for automated query in batch files.
    
     *Syntax :
       axbase -s=<database name> [-q="<query>"]  [-f=<target file name>]
    
     With -s option only AxBase run the user interface and open the <database name> base.
     If -q option is used, AxBase open the <database name> base without the user interface, execute 
     the <Query> SQL query and close.
     With -f (needs -q)  a file is created with the result of query, the format is depending on the file extension, 
     only csv & xls are available.
     
     *Exemples : 
       axbase  -s=C:\Datas\demo.mdb -q="update clients  SET CL_SDA='' WHERE  CL_DATEDEP IS NOT NULL AND CL_SDA <> ''"
       axbase  -s=C:\Datas\demo.mdb -q="SELECT * FROM CLIENTS" -f="c:\cl.csv"
     
     *Remark : replace wildcard % by %% in queries because problems to use % in windows batch files.
    
       axbase  -s=C:\Datas\demo.mdb -q="SELECT CLIENTS WHERE  CL_NOM LIKE 'T%%' "
    Source: ReadMe.txt, updated 2012-01-04