Does Anyone have the code to connect to the localDB from within VBA in ACCESS. ADODB

[sesproul]

Hello,

I've got Access 2007, and I am trying to connect to the DB that the VBA is running in (The local DB) how is this accomplished. or is there a prefered method to work with Recordsets from within the ACCESS program.


I am only familiar with connecting to remote objects, and Databases with code, not looking into the database I am "on".


Steve

[sesproul]

This seems to be the answer:


Dim oconn as Adodb.connection
Set oconn = CurrentProject.Connection