Runtime Error

  • Thread starter Thread starter Mike B
  • Start date Start date
M

Mike B

I have inherited an Access dbase that is linked to another
Access database. The dbase was on a server that no longer
exists. The path to the dbase has changed. When launching
the dbase, Runtime error 3044 is displayed stating the
path is not valid.

How do I get in to the dbase to change the path?
 
You can relink the table by setting the connect property of TableDef.

Dim dbs as DataBase
Dim tdf as DAO.TableDef

set dbc=CurrentDB
For each tdf in dbs.TableDefs
tdf.Connect = "<New Path>"
tdf.Refreshlink
Next

Search and see knowlege base document (Q209862) or MS Access help for
detail.
 
Back
Top