using Joins with acess & DW MX

[Doc]

I have been trying to get the JOIN sql function to work
with access to no avail!! any suggestions? I know I am
wording the query string properly according to several sql
books so it's either DW or Access
Doc

 

[Dirk Goldgar]

I have been trying to get the JOIN sql function to work
with access to no avail!! any suggestions? I know I am
wording the query string properly according to several sql
books so it's either DW or Access
Doc

Um ... what's DW? And why don't you post the SQL? Are you actually
running Access and executing the query there, or are you using DAO from
inside DW (whatever that is) to query an Access database?

 

[Dave]

Access has it's own "dialect" eg "INNER JOIN"

 

[Arvin Meyer]

Um ... what's DW? And why don't you post the SQL? Are you actually
running Access and executing the query there, or are you using DAO from
inside DW (whatever that is) to query an Access database?

DW is probably DreamWeaver which would typically use ColdFusion or ASP to
access the Access database. Posting the SQL, as you mention will help us
give him the answer.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access