Error 3024 File Not Found

Question

I export some information from SAP in Microsoft Access (2007) and then run some VBA coding on it to generate metrics based off a specific sequence of queries. It has been working quite nicely until I transferred the database to another computer. Now I get the Run Time Error 3024 Could not find File 'WOMP Metrics'. When I click on the Debug tton, it take me to:

' The Overall name of this data base is WOMP Metrics

Set db = OpenDatabase("Womp Metrics") <- this is highlighted in yellow.

I do start the module with:

Public Function AnalyzeMetrics()

Dim strSQL As String

Dim strSQL2 As String

Dim strSQL3 As String

Dim strSQL4 As String

Dim strSQL5 As String

Dim db As DAO.Database

Dim FRM As Form

Dim RST1 As DAO.Recordset

Dim RST2 As DAO.Recordset

etc. etc.

Everything is contained within this database. I do use SQL strings for some of the queries but the program never get there. How can I proceed to make this work on another computer?

Answer 1

WOMP Metrics is a the name of an Access database usually located in C:\data\access.

I moved the file from the Flash drive to the same directory on another machine. It worked! The troubling thing is I am pretty sure I tried this in the office. I will try it again....

Answer 2

What is Womp Metrics? Since you do not specify a location for the file Access is probably looking in either the same folder as the app you are working in or the My Documents folder. 

So it depends on what it is to determine how to tell Access to find it.

Answer 3

"WOMP Metrics" could be an ODBC DSN that does not exist (check the ODBC applet) or it is NOT the name of an Access database (which would more likely be "c:\myfolder\womp_metrics..accdb").