parameter queries and runtime

C

Chip

I just started reviewing a conversion project. The client has Access 2000
databases now running in access 2007 runtime. Any parameter queries with one
parameter run fine. Any queries with multiple parameters return an empty
recordset. The multiple parameters are prompts for dates thentext with
wildcards.
Is this an issue with the free downloaded runtime?
 
A

Allen Browne

It's probably a difference in the way Access is understanding the
parameters.

Post the SQL statement of the query that fails.
(Switch to SQL View, copy'n'paste here.)

Also, tell us the data type of the fields you are applying parameters to (by
opening the table in design view, and looking in the Data Type column.)

My guess is that the solution will be to declare the date parameters, and
ensure the Nulls and joins are handled correctly.
 

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

Similar Threads

error in runtime: bad query parameter 11
Access 2007 Runtime 5
Prompts from one parameter query appearing in all queries 2
Access 2007 Runtime and dates - SQL 4
Date() and Access 2007 Runtime 15
Access 2007 Runtime vs. Full Install 8
Access Runtime 5
Microsoft Access Developer and Runtime 1

Top