A2003 prompts for query parameter values...

R

Raja

I have an Access database application that was written in Access 2000. I have
converted the database to Access 2003 format. When I run the applicaion in
Access 2003 it is prompting me to enter value for all the "WHERE" clause
values in any query.
For e.g. when it executes the following line

Me.RecordSource = "Select * from qryHierarchy where appID=1"

I get a popup box to ask me enter appID, though I have hardcoded appID=1. It
is the same case for all queries in my application. This application works
well in Access 2000 and Access 2002 (SP2). It does not work in Access 2003
and Access 2002 (SP3)

Does anyone have any idea about whats going on here...
Thanks in advace for your help.

Regards,
Raja
 
D

Douglas J. Steele

Is it possible that the field name somehow got changed from appID in
qryHierarchy?
 

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

input popup only in Access 2003 1
Annoying Access 2003 Query bug. Fix available? 1
SQL Select Query Prompting for NonExistent Parameter 8
Multiple parameter prompt in a query (InParam) 2
a2003-code doesn't work 3
Iterate through repeating table with complex SQL query 1
An A2003 to A2007 security question 1
Update Query: Enter Parameter Value 2

Top