AccessMDB

Requirements:
MSAccess and JET on the computer
Make MDB:
Make a file with MSAccess
For example c:\temp\test.mdb
Make table:
Make a table in the mdb file with MSAccess
For example, columns named ColA and ColB in the table named TestTable
Select from table:
Input in SALAD follows.
[SALAD]
$mdb = "c:\temp\test.mdb";
$sql = "select * from [TestTable]";
$acc = new AccessClient;
$acc.ExecuteSelectQuery($mdb, $sql);
Insert into table:
Input in SALAD follows.
[SALAD]
$mdb = "c:\temp\test.mdb";
$sql = "insert into [TestTable] ([ColA],[ColB]) values ('ValueA', 'ValueB')";
$acc = new AccessClient;
$acc.ExecuteNonQuery($mdb, $sql);

See also AccessClient.

Last edited Mar 2, 2013 at 2:51 PM by Tom__S, version 8

Comments

No comments yet.