-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Usually, that error means there is a general error in the SQL (not,
necessarily, a parameter error). If you are using something like the
Access "SQL Pass Through Query" in Windows SQL then your SQL string will
not work in an Access (JET) db. I don't believe you can use another
program to initiate parameterized queries in Access unless you open
Access as an Automation object (OLE). This means you will have to
dynamically create a valid Access SQL string to send to the Access query
engine.
Get the Access Help file or a book on Access SQL programming. There
are, probably, articles on the Internet about Access SQL programming.
Search via Google.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQbVel4echKqOuFEgEQJnSwCdFGUSPL3GcA0YDe20CVvsty 72tzgAoKRP
t6eGFdFeD+hSMsgLjQz3rYuS
=tHjq
-----END PGP SIGNATURE-----
Bibi wrote:[color=blue]
> Hi,
>
> i have a SqlWindows Program which made a connection to a MS Access
> Database about ODBC. I can get all datas with a select about one table. But when
> i made a select with more than one table, i get the following message:
>
> "ACCESS:-3010[Microsoft][ODBC Microsoft Access Driver] 1 Parameter
> wurden erwartet, aber es wurden zu wenig Parameter übergeben."
>
> Can somebody help me ?
>
> This message means, that the program wait for 1 parameter, but there
> are too little parameters received.
>
> The select like this:
> " select a, b, c from lks_abc, lks_xx, lks_yy into :cola, :colb, :colc
> where abc = xx.abc and abc = yy.abc"
>
> I run this select with "SqlPrepareAndExecute" and then "SqlFetchNext".
>
> It´s MS Access 2000 and SqlWindows 2000.[/color]
