Database access using ODBC

Hi, Long time reader, first time poster! I am new to php coming from a generally MS (unfortunately) background (Access, VB, SQLServer) and I am looking to branch out a bit. I have a client who wishes to have an internet front-end to an Access database. I am using php with odbc to access this and (as I am a newbie), I am having problems with the connection. After I do an odbc_pConnect, when I call the odbc_exec, I get the usual error, Warning: Supplied agrument is not a valid ODBC-Link resource. The ODBC DSN is setup as standard (no default login etc). The following code is being used for db access: function DBRetrieve($pSQLStr) { global $DBConn, $DBQryID, $DBQryRows, $DBQryColumns; $DBDsn='PHPTEST'; $DBUser='Admin'; $DBPassword =''; #Open a persistent connection to the database if (!$DBConn = (odbc_pConnect($DBDsn, $DBUser, $DBPassword) or die("Database Execution Error: " . odbc_Error() . " " . odbc_ErrorMsg()))) { echo "\nError connecting to database\n"; return false; } #Send query to database if (!$DBQryID=(odbc_Exec($DBConn, $pSQLStr) or die("Database Execution Error: " . odbc_Error() . " " . odbc_ErrorMsg()))) { echo "\nError executing database request: [ODBC_EXEC]\n"; DBDestroy(); return false; } #Get no of rows in recordset if (!$DBQryRows=(odbc_num_rows($DBQryId) or die("Database Execution Error: " . odbc_Error() . " " . odbc_ErrorMsg()))) { echo "\nError executing database request: [ODBC_NUM_ROWS]\n"; DBDestroy(); return false; } #Get number of fields to display if (!$DBQryColumns=(odbc_num_fields($DBQryId) or die("Database Execution Error: " . odbc_Error() . " " . odbc_ErrorMsg()))) { echo "\nError executing database request: [ODBC_NUM_FIELDS]\n"; DBDestroy(); return false; } return true; } Does this look ok to you more experienced guys? Am I missing something or is there a better way? Thanks. Colum -------------------------------------------------------------------- Mail2Web - Check your email from the web at http://www.mail2web.com/ .