ADO connection

[Perico]

I have an Access2K front end and a SQL2k backend. When
clicking a button on a form, the form passes the contents
of a textbox on the form to a query as a parameter. Based
on the queries return results, the form takes any number
of actions.

I've found I can use DAO to pass this parameter, but when
I try it with ADO I get the message, "database place in
state where it cannot be loaded or opened."

So here's the question: If you have an Access front end
and a SQL backend, but you're passing a parameter from a
form to an ACCESS query contained in the same database as
your forms, is this even doable with ADO? No action
queries are involved, only a select query that takes one
parameter from a textbox on the form.

(There seem to be more responses in this section than in
the ADO section.)

 

[Ben]

Normally, I concatenate the value into the SQL or string, or better, use
a stored procedure and pass the values as a parameter. You said A2K &
SQL so I assume you are using an ADP. If so, I don't think that use the
[form]![control] syntax in the query.

HTH
Ben