I have gotten this to work by supplying a full server path, ie
//server-name/path/
Mapped drives do not translate well.
You also have to give the account the server is running under access to the
server.
Dewey Williams
-Original Message-
From: M.Staiger [mailto:[EMAIL PROTECTED]
Sent:
It seems the use of LIKE in an sql statement requires the 'wild-card' %
instead of * when sending to an Access (and other?) databases. If anyone
knows WHY, I would like an explanation.
Dewey Williams
[EMAIL PROTECTED]
-Original Message-----
From: Williams, Dewey [mailto:[EMAIL
HELP!
I am trying to write an sql statement to get data from my Access database
through ODBC. Everything works okay if I write a simple Select statement,
but I need to write a statement like:
"SELECT Files.Fileame, Products.ProdName FROM Products INNER JOIN Files ON
Products.bid = Files.bid WHE
