TCP connector for access (1 Viewer)

[-ian-]

I am trying to create a vb client and server to behave as an interface to access over TCP/IP using winsock.

My motivation is to have the server produce full logs of access to the database mdb file, and to log all the SQL edit requests to allow for roll-back, and restore the db after corruption.

I have seen some good resources on the net for creating a client and server and have applied those successfully. I am however having problems with the maintaining flow from the selects to functions like rs.movenexts.

Anyone any ideas or pointers on how to proceed? I am currently looking at stacking the returns from selects into arrays and processing them... but its looking nasty.

Kind Regards,
Ian./

 

[GST]

Ian,

Sorry I don't think I can help you on your post, but maybe
you can help me.

I have a couple of questions.

In some of the posts I have reviewed it says to create a winsock
control. I cannot find the "reference" that allows me to create a
a winsock control. From reviewing some documents it says that
the winsock control is in the MOD ActiveX Controls. Are these
ActiveX Controls only available with Office Developer or is there
another "reference" I can use to create a winsock control?

If you can help or if you could direct me to other posts or another
forum that I could find out more information it would be greatly
appreciated.

Once again sorry I am not knowledgable to help on your post.

Thanks,

Gary