COMException unhandled error: invalid file

[v_fas]

I keep getting an error on the following code:

db = DAODBEngine_definst.OpenDatabase(
"Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\Temp\MyAccess2007.accdb;Persist Security Info=False;")

I already have installed the Access 12 driver.
Any ideas?

 

[Stuart McCall]

I keep getting an error on the following code:

db = DAODBEngine_definst.OpenDatabase(
"Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\Temp\MyAccess2007.accdb;Persist Security Info=False;")

I already have installed the Access 12 driver.
Any ideas?

Have you tried Set db, ie:

Set db = DAODBEngine_definst.OpenDatabase...

Also, DAODBEngine_definst needs to be declared (and set up) as a Workspace
object.

 

[v_fas]

How do you set it up as a Workspace object?

Have you tried Set db, ie:

Set db = DAODBEngine_definst.OpenDatabase...

Also, DAODBEngine_definst needs to be declared (and set up) as a Workspace
object.

 

[v_fas]

Dim wrk As dao.Workspace

Have you tried Set db, ie:

Set db = DAODBEngine_definst.OpenDatabase...

Also, DAODBEngine_definst needs to be declared (and set up) as a Workspace
object.

 

[Stuart McCall]

Dim wrk As dao.Workspace

Using wrk instead of DAODBEngine_definst:

Dim wrk As DAO.Workspace
Set wrk = DAO.Workspaces(0)
Set db = wrk.OpenDatabase(...