I have a procedure that uses ADOX to create a database with a table.
That works fine. I then need to populate that table with a record but
the code is not working. I believe that the database is still locked.
Dim lcat as New ADOX.Catalog
Dim ltbl As New ADOX.Table
lcat.Create(connection)
' Code to create table.
ltbl = Nothing
lcat = Nothing
In the same procedure, I create a connection to execute a INSERT
command, but an error is generated on the lcnn.open()
Dim lcnn As Data.OleDb.OleDbConnection
lcnn = New Data.OleDb.OleDbConnection(lstrConnection)
lcnn.Open()
Thanks!