Access asks for Paramter when Criteria contains @

  • Thread starter Thread starter Christian Sommer
  • Start date Start date
C

Christian Sommer

Hi,

I change the RecordSource of a form to:
select BC.* from T_BusinessContact BC WHERE (BC.[Mail1]
like '%[email protected]%' OR BC.[Mail2] like '%
(e-mail address removed)%')

Now Access asks me to insert a Value for the Parameter
kpmg.com%'

Access shouldn't ask me anything just return the rows!

Do you have any idea what I can change?

Thanks!
 
Hi Daran,

I'm using SQL Server 2000 and Access XP.

The Problem is even worth now. Because even after I chnaged the Query back
to a Select without Criteria, Access still keeps asking me the same
Question!

Is there a way to ged rid of this?

Thanks for any help.

Christian

Daran Johnson said:
Christian,

Are you using Access JET, MSDE, or SQL Server for your backend?

-Daran

Christian Sommer said:
Hi,

I change the RecordSource of a form to:
select BC.* from T_BusinessContact BC WHERE (BC.[Mail1]
like '%[email protected]%' OR BC.[Mail2] like '%
(e-mail address removed)%')

Now Access asks me to insert a Value for the Parameter
kpmg.com%'

Access shouldn't ask me anything just return the rows!

Do you have any idea what I can change?

Thanks!
Click to expand...
Click to expand...
 
Christian,

Use Profiler and check what statement is being sent to the server. If you
haven't done this before then launch Profiler and go to File/New/Trace and
select the server then run the standard template.

Execute the query from the Access form and it should show up in the Profiler
screen.

Profiler will show the SQL statement it received. That is a good place to
start to find the trouble.

-Daran

Christian Sommer said:
Hi Daran,

I'm using SQL Server 2000 and Access XP.

The Problem is even worth now. Because even after I chnaged the Query back
to a Select without Criteria, Access still keeps asking me the same
Question!

Is there a way to ged rid of this?

Thanks for any help.

Christian

Daran Johnson said:
Christian,

Are you using Access JET, MSDE, or SQL Server for your backend?

-Daran

Hi,

I change the RecordSource of a form to:
select BC.* from T_BusinessContact BC WHERE (BC.[Mail1]
like '%[email protected]%' OR BC.[Mail2] like '%
(e-mail address removed)%')

Now Access asks me to insert a Value for the Parameter
kpmg.com%'

Access shouldn't ask me anything just return the rows!

Do you have any idea what I can change?

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top