How Do I .....

[Derek]

Hi,
Everyone at work has given me different methods to connect to an access database and they have worked but i would like to know one correct method or maybe the one you guys use to connect using ADO in visual basic.
I would like to stick to one method only, so if you guys could help me out i would appreciate it alot.
Derek.

PS: A method to either insert or update would be great.

[Lothar Haensler]

what's wrong with having several different correct methods for connecting to a database?
There is no "right" or "wrong" method IMHO.
I call that flexibility. The ADO object model is fairly flexible.

If you'd like to stick to one method, I suggest you choose the one that you like.