Connection String

[AccessDev]

Can smeone please give a complete connection string using DAO. I then need to open a connection in turn a recordset and perform a dlookup.

many thanks for any help

 

[Steve R.]

You don't need a connection string for DAO.

Dim dbstemp As DAO.Database
Dim rsttemp As DAO.Recordset
Set dbstemp = CurrentDb
Set rsttemp = dbstemp.OpenRecordset("authortemp", dbOpenDynaset)

 

[AccessDev]

Many thakns for your reply