Database problem

Hi,
how do I disconnect from a Access database using ADODC ?
I've created a front end to populate a database table with attributes from a drawing and view or even edit them on a form. This works fine, but if I change some of the attributes in a drawing I have to update the database table. It only works if I close my program. Autocad will not overwrite the existing table, even if I give it a permission. I suppose disconnecting from a database will do the trick - but how is that accomplished ?

Yours
Seppo Peltomaa

 

The problem might be in your recordset.
Make sure that is updateable

Myrecordset.LockType = adLockOptimistic

before you open it.

 

Thanks Jorge,
I tried it, but in vain. The problem might be that the DataGrid where the records go does not "accept" a recordset as a datasource from code. In properties window it will take adodc1 control. So I suppose that the connection is on if I can not change that value or disconnect adodc1. It seems that I do not have enough knowledge to do this kind of things, but I try

yours
Seppo Peltomaa

 

....
myrecordset.open sqlstring
Set DataGrid1.Datasource = myrecordset
....

 

Thanks Jorge,
I got it. It works now.

Yours
Seppo Peltomaa