Access 2007 - Cannot open current database

[Trudie Davies]

Hi

I am trying to reference the current database and copied the following code
from the help file:

Dim dbsNorthwind As Database
Dim qdfTemp As QueryDef
Dim rstEmployees As Recordset

Set dbsNorthwind = OpenDatabase("Northwind.mdb")
Set qdfTemp = dbsNorthwind.CreateQueryDef("")


When I try and add my database name which is "EPCProcessDatabase.accdb" I
get the run time error 3024 cannot find database. Can anyone help?

Thanks

 

[Alex Dybenko]

Hi,
make sure that you entered the full path to EPCProcessDatabase.accdb

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com