CodeCharge Studio
search Register Login  

Web Reporting

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

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

 Access Query

Print topic Send  topic

Author Message
Luis2004

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

Louis,
View profile  Send private message
dataobjx


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????
_________________
www.DataObjx.net
www.mydigitalapps.com
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?


John
mrachow


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

Try '%name%'
_________________
Best regards,
Michael
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 http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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