ODBC Fail

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access database that is connecting to our AS400 through client
access. The connection to the 400 is okay because I can view the linked
table when I open the table in the program. When I write a query on the file
it does not appear to like the Between statement. I say that because when I
just put in one date
 
Looks like you got cut off... but FWIW, the Between...And operator needs two
dates.

Also, the AS400 may not recognize that operator, so you may need to use
greater than and less than symbols instead. <, >, <=, >=
 
You must log in or register to reply here.

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

update query ODBC--call failed 3
odbc 1
Pass-Through Query / Multiple ODBC Connections 1
Pass Through Queries 1
ODBC Pass-Through Queries 2
ODBC errors? 4
How do I solve ODBC-call error on pass-through query? 3
Problem querying table linked ODBC Database 2

Back
Top