AMSSpecialist

-- Connect to a MS Access database

result = ODBC.OpenDirectConnection("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\mytable.mdb;");



-- perform an operation without resultset

result = ODBC.ExecuteSQL("UPDATE tablename SET column=value WHERE field=criteria");



-- perform a query allowing to retrieve records

result = ODBC.OpenQuery("SELECT * FROM client");