I have a command button with the onclick() action as below
Dim curDB As Database
Set curDB = CurrentDb
curDB.Execute "CREATE TEMPORARY TABLE test10 (ID INT)"
curDB.Execute "Insert into test10 (ID) values ('001')"
curDB.Close
The create statement gives me an error....
How do I create a temporary table?
Dim curDB As Database
Set curDB = CurrentDb
curDB.Execute "CREATE TEMPORARY TABLE test10 (ID INT)"
curDB.Execute "Insert into test10 (ID) values ('001')"
curDB.Close
The create statement gives me an error....
How do I create a temporary table?