Simulating temp tables for mdb?

  • Thread starter Thread starter Edwin Knoppert
  • Start date Start date
E

Edwin Knoppert

I'm trying to work out a temp table situation for oledb>mdb stuff.
I simulate this using a transaction > rollback in a class (+disposed
implemented and such).
But i can not get me a 2nd instance, it gives me a already open connection
or sort of on my computer.
Of course, i test two seperate connection objects.

How can i do this?

Each class instance set's up an unique connection object, transaction
object, command to create an unique table(name).


Thanks!
 
Info:

cmd.ExecuteNonQuery fails:
System.Data.OleDb.OleDbException: Bijwerken is niet mogelijk. Het object
wordt momenteel gebruikt door de gebruiker (bla bla) en is vergrendeld.

Which means: locked
 
Edwin,

Will we help you than we have at least to see your code with which you open
the database and make the commands.

Cor
 
Back
Top