FrontAccounting forum — MS Access integration with FA

Re: MS Access integration with FA

null@example.com (apmuthu) — Wed, 18 Jan 2017 08:36:01 +0000

Before safely using strings in SQL statements, cleaning them up has traditionally been done using the likes of mysql_real_escape_string and add_slashes. Whilst the latter can be used for insertion/updation of records in MS Access, the following function will be suited for many instances where offending/unsafe/exploitable characters need to be stripped:

function msaccess_escape_string($str) {
    $lf = "\n";
    $str = str_replace(Array("'", '"', "\t", "\r", $lf, "\\"),"", $str);
    if ($str == NULL) $str = ' '; // Access does not allow null fields to be blank in insert using this method
    return $str;
}

Re: MS Access integration with FA

null@example.com (apmuthu) — Sun, 15 Jan 2017 12:09:42 +0000

Migrating data from any string format especially the MySQL ANSI date format yyyy-mm-dd into MS Access Short Date format irrespective of the locale setting (m/d/Y or d/m/Y) is done using the DateValue(str DateAsString) function.

MS Access integration with FA

null@example.com (apmuthu) — Sun, 15 Jan 2017 09:31:54 +0000

FA uses MySQL whilst many applications use MS Access. PHP on Windows allows for interfacing with both MySQL and MS Access. Attached herewith is the possible choice of PHP data connection strings for both MDB and ACCDB versions (2000 and 2007) of MS Access databases and sample usage PHP code to interface with it.

Those who run POS applications based on MS Access can use this means to interface with FA.

Further interfacing sample code is available in my GitHub repo.