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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query works in Jet 3.5.11 and not Jet 4.0
Thanks, Cheerio. After receiving your response, I rewrote my query as an Inner Join and tested it on the Jet 3.5.11 server. It worked fine. Then I copied it to the Jet 4.0 and received the same 'Unspecified Error' as before. Any additional ideas?- ERDaniels
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Query works in Jet 3.5.11 and not Jet 4.0
I am using a query in Jet 3.5.11 on an IIS 4.0 and NT server that displays data from two Access 97 tables. This same query when running on Jet 4.0 produces a 80005004 "Unspecified Error". What can be causing this problem? My Query = "Select complete.dbUserID, names.dbName...- ERDaniels
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
