How to Properly Define Parameter Workaround

J

JHeide58

I'm receiving the error message below from my DRW Access query search. I've found MS's workaround suggestion on the web, but it's greek to mee. Can someone please explain how one properly defines a parameter object thru the Database Results Wizard.
Thanks, JH

Database Results Wizard Error
Description: Parameter object is improperly defined. Inconsistent or incomplete information was provided.
Number: 3708 (0xE7C)
Source: ADODB.Recordset
 
J

Jim Buyens

This sort of message usually means you're trying to
display a field that doesn't exist. The database assumes
the misspelled field is a parameter; that is, a name for
which you'll supply a value at run time. But the DRW
never supplies values for parameters, and so you get an
error.

Bottom line: rerun teh wizard and make sure all your
field names are (1) spelled correctly (2) not using
reserved words like date and timestamp.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


-----Original Message-----
I'm receiving the error message below from my DRW Access
query search. I've found MS's workaround suggestion on
the web, but it's greek to mee. Can someone please
explain how one properly defines a parameter object thru
the Database Results Wizard.
Thanks, JH

Database Results Wizard Error
Description: Parameter object is improperly defined.
Inconsistent or incomplete information was provided.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top