• From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,201

Topic: MS Access integration with FA

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.

Post's attachments

MS Access Connection to PHP in WinXP.png 109.3 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,201

Re: MS Access integration with FA

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.

Post's attachments

MS Access DateValue function.png 56.9 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,201

Re: MS Access integration with FA

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;
}

apmuthu's Website