On 12/31/2002 09:57 AM, [EMAIL PROTECTED] wrote:
I'm trying to run a parameterised query in MS Access using odbc_prepare and
odbc_execute but to no avail.

The error message I'm getting is:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1., SQL state 07001 in SQLExecute in c:
\inetpub\wwwroot\test\access_db.php on line 17

I've read conflicting messages saying that this paramaterised queries with
Access do or don't work. Any definitive answer?
The definitive answer is no, despite I don't see why not. It seems to be a problem with PHP.

Anyway, you may want to try Metabase which is a PHP abstraction package for developing portable PHP database applications. It supports prepared queries. It comes with a ODBC driver and a sub-driver specialized in Microsoft Access.

Metabase is Open Source and is available here:


There is a version that is about to be released that includes the specialized ODBC MS Access driver but that is only available for beta testing here:



Manuel Lemos

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to