jet engine error

[jokobe]

Hi ng,

I have the following problem. I have stored a value in a
global variable. This value is needed in a query like this:

Dim rs_collect As ADODB.Recordset
Set rs_collect = New ADODB.Recordset
Set rs_collect.ActiveConnection =
CurrentProject.Connection

rs_collect.Open "a_query"

a_query is stored like this:
SELECT COUNT([datum]) AS stammdat
FROM stamm_lieferplan
WITH OWNERACCESS OPTION;
Now I receive the error message: SQL ... not
allowed. "Delete, Select ... expected"

Any helpful hint?

jokobe