Relink to dbase File 1

[vich]

I am trying to relink to a dabase file on another drive using the following code an get an error stating that the file does not exist, which it does. I know I am overlooking something obvious. Help would be appreciated very much.

Thanks

Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim tbl As TableDef
Set db = CurrentDb()
Set tbl = db.TableDefs("CELabels")
tbl.Connect = "Dbase IV;DATABASE=V:\FMS\CELabels.dbf"
tbl.RefreshLink

 

[Remou]

When connecting to DBase, you use the directory in which the tables reside as the 'database'. The table name is added to SourceTableName.

   Dim db As DAO.Database
    Dim rs As DAO.Recordset
    Dim tbl As TableDef
    Set db = CurrentDb()
    Set tbl = db.TableDefs("CELabels")
    tbl.Connect = "Dbase IV;DATABASE=V:\FMS"
    tbl.SourceTableName = "CELabels.dbf"
    tbl.RefreshLink

You may wish to use: HDR=NO;IMEX=2; in your connect string.

 

[vich]

Perfect!

Thanks VERY much for the help!!