Apr 26th, 2000, 09:21 AM
I get an error when I try to execute the following SQL statement. If I execute each select statement by it's self, it runs fine. When I put them together with a union I get an error. The tables exist and the names are spelled correctly. Any insight is appreciated.
SQLString = "SELECT SALEID FROM PRESALES UNION ALL SELECT SALEID FROM SALES"
Set SearchRec = AutoSalonDb.OpenRecordset(SQLStrig, dbOpenSnapshot)
Error
Run-time error '3078'
The microsoft jet database engine can not find the input table or query. Make sure it exists and that its name is spelled correctly.
SQLString = "SELECT SALEID FROM PRESALES UNION ALL SELECT SALEID FROM SALES"
Set SearchRec = AutoSalonDb.OpenRecordset(SQLStrig, dbOpenSnapshot)
Error
Run-time error '3078'
The microsoft jet database engine can not find the input table or query. Make sure it exists and that its name is spelled correctly.