SantoBugito
Programmer
I am creating a query in a access database, the call I use is
Set qdfNew = NewDB.CreateQueryDef("Summary Info", _
"SELECT [National Call Information].*, [International Call Information].*, [Network Call Information].*, [Total Call Stats].* FROM " & _
"[National Call Information], [Network Call Information], [Total Call Stats], [International Call Information]"
When I come to execute it later in the program using the following call
Set RS = condb.OpenRecordset("Summary Info", dbOpenSnapshot)
I get the following error
37000: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
Has anybody got any idea why this is happening?
Thanks in Advance
Sean
Set qdfNew = NewDB.CreateQueryDef("Summary Info", _
"SELECT [National Call Information].*, [International Call Information].*, [Network Call Information].*, [Total Call Stats].* FROM " & _
"[National Call Information], [Network Call Information], [Total Call Stats], [International Call Information]"
When I come to execute it later in the program using the following call
Set RS = condb.OpenRecordset("Summary Info", dbOpenSnapshot)
I get the following error
37000: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
Has anybody got any idea why this is happening?
Thanks in Advance
Sean