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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export an Access Table as an dbase III file 8
error 3011 and error 3343 2
Dbase Crazy Flicker Crash 3
Mapping to Database 1
TransferDataBase won't work 3
splitting dbase in a different network drive 1
Access 2007 runtime? 2
Coding Question 2

Back
Top