Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
JetSQL syntax using external Db with LEFT JOINs
That worked. Here's the final working version. Thanks for the help. <% Set adoConn = Server.CreateObject("ADODB.Connection") adoConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Mid(Request.ServerVariables("PATH_TRANSLATED"), 1, Len(Request.ServerVariables("PATH_TRANSLATED")) -...- bildun
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
JetSQL syntax using external Db with LEFT JOINs
I'm not familar with DAO. In this particular situation I have a mdb file for logging and such that exists only on the web site and another mdb file that is uploaded daily from a clients accounting application. I figure I could "simulate" a JOIN with an array instead but I'd rather do that as a...- bildun
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
JetSQL syntax using external Db with LEFT JOINs
I tried that and I get the same error - Syntax error in FROM clause.- bildun
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
JetSQL syntax using external Db with LEFT JOINs
I've got the following bit of code I'm trying to work with to get a JOIN to work in like fields in two mdb files with ASP. What I have below just gives me a syntax error on the FROM clause. I'm trying to JOIN the users table in the users.mdb database with the username field in the videolog...- bildun
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
-
Select from two databases
Is it possible to do a select and join from two seperate Access databases with ASP? If so, how?- bildun
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
