There's two ways to go about it; to launch Access via COM as an application or to use "ADOdc"

ADOdc is a wrapper class that is meant to take the hassle out of writing to and from databases.

ADOdc is the better solution here. You will want to heckle VB forums about its use.

Let me say that while its great you want to use COM, its not so great that your running into heckles like this.
You should be experienced in COM (Or at least VB) to take on a task of this size.

Might I suggest you reconsider and make use of the mySQL DLL on mircscripts.org? It's an easier solution by half (IMHO)

I'm sorry to say I'm not experienced enough with ADOdc to help you out in completing the script; not many people on this forum would be.

--
*DOH*
I went away from the PC and online slips in a post. Well, I guess I'm wrong :P

Last edited by CloCkWeRX; 01/08/03 02:17 AM.