CREATE TABLE with no columns

  • Thread starter Thread starter peregenem
  • Start date Start date
P

peregenem

Anyone noticed this one?

CurrentProject.Connection.Execute _
"CREATE TABLE Oops;"

Set rs = _
CurrentProject.Connection.Execute _
("SELECT COUNT(*) FROM Oops;")
 
[email protected] said:
Set rs = _
CurrentProject.Connection.Execute _
("SELECT COUNT(*) FROM Oops;")
Click to expand...

A workaround for this (unusual) error:

Set rs = _
CurrentProject.Connection.OpenSchema(adSchemaStatistics)

rs.Filter = "TABLE_NAME = 'Oops'"

MsgBox rs.Fields("CARDINALITY").Value
 
Back
Top