Re: Cannot Open RecordSet
IMHO this should rather look like this:
cmd.CommandType = adCmdText
set cmd.ActiveConnection = cnnMyConnection
cmd.CommandText = "Create Table MyTable "
' create the table
cmd.Execute
' now open a recordset
cmd.commandtext = "select * from mytable"
set rsTable = cmd.Execute
...
Re: Cannot Open RecordSet
At the second .Execute :
I've got error "Could not find MyTable"
Looks like the first Excecute does not work
Re: Cannot Open RecordSet
well, I thought that your statement was meant as an example.
Of course "Create table mytable" is not valid SQL. You need to specify the fields of your table as in:
create table mytable(firstfield char(20))
Also, check all errors that you get when executing a statement.