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. I can also run the select statment from the SQL Server Query Analyzer without a problem.


SQLString = "SELECT SALEID FROM PRESALES UNION ALL SELECT SALEID FROM SALES"
Set SearchRec = AutoSalonDb.OpenRecordset(SQLString, dbOpenSnapshot)

Error Message

Run-time error '3078'
The microsoft jet database engine can not find the input table or query 'SELECT SALEID FROM PRESALES'. Make sure it exists and that its name is spelled correctly.