update linked table

[Michel]

I've an Access 2k database as user interface and an sql server to store the
data.
I'd like to change the database in vb.
How can I do this?
If I had an Access database for the data I could do somethings like this

table.name = tmpTableName
CurrentDb.TableDefs.Refresh
Set tdf = CurrentDb.CreateTableDef(tableName)
tdf.Connect = connectionString
tdf.SourceTableName = prefix & tableName
tdf.Attributes = dbAttachSavePWD
CurrentDb.TableDefs.Append tdf
Call DoCmd.DeleteObject(acTable, tmpTableName)

But it doesn't work with sql database. Maybe because it's using ADODB for
sql instead of DAO.
So how can I do this?

Michel