CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> Help/Consulting -> Help - Jobs Available

 Access Query

Print topic Send  topic

Author Message

Posts: 1
Posted: 06/29/2004, 2:42 PM

Hi there,

I connect Access database to a sql server back end database. All I did was link tables to sql server. When I run a query using the criteria Like "*name*" I dont get any data back, but if I run the query without the criteria Like "*name*" I get all the data.

can you please help me to come out with a solution?

Thank you so much

View profile  Send private message

Posts: 181
Posted: 07/14/2004, 7:57 AM

Could you explain this a bit better...

Also, post the sql you're using in both instances.

Do you mean that when you run the query in MS Access you don't get any records but when you run the query in MS SQL Server you do????
View profile  Send private message
John Dillon
Posted: 01/20/2005, 1:21 PM

A couple of questions I have:

Are you using pass through queries or straight Access Queries?
What Version of Access and SQL server are you using?


Posts: 509
Posted: 01/20/2005, 11:34 PM

Try '%name%'
Best regards,
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.