Well, I'm not sure what your activeX component is buying you. You can create a recordset pretty easily in ASP VBScript with no ActiveX at all....

If your going to use an ActiveX component for your data services, which is not a bad idea at all, you should keep all your data reads and writes in the activeX component.

That way the only way data can be written to the database is through your component.

That includes creating your connection. Your component does not have access to the connection object you are opening in the ASP page. It is out of scope. It should also be opened inside the component.

Pass the values you are changing to a method in the component where you can update the database.