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

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

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


"Trudie Davies" <Trudie (E-Mail Removed)> wrote in message
news:005188F0-E0DC-484D-AC3A-(E-Mail Removed)...
> 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