Thanks for the help.
I should have included a sql statement as I'm sure you guys would have know
Access uses different date format.
I was using
DATEADD(MM, 8, '01/01/1999')
and the access driver seems to like
DATEADD('M', 8, '01/01/1999'))
-----Original Message-----
From: Zaid Abdur-Rahman [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 9:58 AM
To: ActiveServerPages
Subject: Re: access odbc error
Check for reserved words. Try putting square brackets around your [field
name]
HTH
----- Original Message -----
From: "Tyler Brown" <[EMAIL PROTECTED]>
To: "ActiveServerPages" <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 4:17 PM
Subject: access odbc error
>
> Why am I getting this error:
>
> >Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
> >[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 4.
> >/inet/query_manager.asp, line 94
>
> the identical sql query works fine via a sql ODBC but I need to use an
> Access ODBC now.
>
> Microsoft seems to say that this error means the access driver doesn't
> recognize a column, I've checked spelling and case, what's the problem?
>
>
> ---
> You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
