VBA ACCESS - ado connection and recordsets

[meyerlanski]

Hi,
I have been programming in Visual Basic for a while now. I now received a new task which involves programming in VBA and access.
I have created the tables and relationships in access.
I would like a code example of how and where I would have to cretae the connection (using ADO) and how I would go about creating recordsets in VBA.
Thanks.

 

[humbleprogrammer]

Check out

http://www.programmingmsaccess.com/Samples/

 

[humbleprogrammer]

Here's a Microsoft reference

http://support.microsoft.com/default.aspx?scid=kb;en-us;301987