DAO connect Access 2007/2010

[sal21]

How to connect .accb, with VB6 and DAO using Workspace?
Tks.

[HansV]

You have to set a reference to the Microsoft Office 12.0 Access Database Engine Object Library (for Access 2007) or the Microsoft Office 14.0 Access Database Engine Object Library (for Access 2010). You can then use DAO exactly the same way as you are used to.

S136.png

[sal21]

You have to set a reference to the Microsoft Office 12.0 Access Database Engine Object Library (for Access 2007) or the Microsoft Office 14.0 Access Database Engine Object Library (for Access 2010). You can then use DAO exactly the same way as you are used to.

S136.png

Set the reference....

i use:
Option Explicit
Sub UNO()

Dim dbMyDB As DAO.Database, RS As DAO.Recordset

Set dbMyDB = OpenDatabase("C:\DATABASE\T3541.accdb", False, False)

End Sub

correct?

[HansV]

Yes, that should work.