Using methods on_insert, on_after_insert. on_update with MSAccess database table

Questions › Using methods on_insert, on_after_insert. on_update with MSAccess database table

0 Vote Up Vote Down

C3media asked 7 years ago

Hello,

It´s possible to use methods for insert or update data based in MSAccess database table changes in operation?

2 Answers

0 Vote Up Vote Down

Abu Ghufran answered 7 years ago

Yes, its doable exactly as in other databases.
Sample connecting settings are:

$db_conf = array();
$db_conf["type"] = "pdo";
$db_conf["server"] = "odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=".dirname(__FILE__)."/../../sampledb/northwind.MDB;Uid=;Pwd=;";
$db_conf["user"] = ''; // username
$db_conf["password"] = ''; // password
$db_conf["database"] = ''; // database
$g = new jqgrid($db_conf);

For events, you can refer docs > custom events.

migul replied 5 years ago

NO FUNCIONA CON ACCESS 2016

$db_conf = array();
$db_conf[“type”] = “pdo”;
$loca=dirname(__FILE__).”\cono.accdb”;
echo $loca;
$db_conf[“server”] = “odbc:Driver={Microsoft Access Driver (*.accdb)};Dbq=”.$loca.”;Uid=;Pwd=;”;