Runtime Error

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?
 
K

k3dragon

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.
 
Top