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,
|
|
|
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 |
|
|
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 |
|
|
|