Ændre placering af sammenkædet tabeller

Jeg har ingen forstand på dBaseIV.
Som jeg forstår dig har du en opdelt db, der består af en back-end og en eller flere front-end db, og du ønsker fra en front-end db at ændre placeringen af back-end f.eks. til et andet drev.

Man skal være forsigtig med at sige, at det ikke kan lade sig gøre, men i dette tilfælde føler jeg mig overbevist om, at det er umuligt. Det ligger jo også i begrebet back-end, at det er en db der kun består af tabeller, for at flere brugere i front-end kan trække på data.

Ligeledes hvis du flytter back-end, skal du tilrette front-end db så de kan finde back-end på dens nye placering.

Mvh / Mugs   

Look at DoCmd.TransferDatabase

This is the same as linking tables and it spossible to change the loaction of a linked table and then refresh the link, so I think it is possible.

Example:

1: Link a dBase IV database, and lets say it gets the name YourTabel and its placed on D:\\

2: The following code changes the location of the linked table to D:\\TEMP.

3:Note that sConnect is taken from tdef.Connect C you can see exactly what it is with
msgbox tdef.Connect
before changing it.

sLocation can be a text box on a form, so

sLocatiion = me.txtfield would do the trick!


Dim sConnect as String
Dim sLocation as String

Dim tdef As TableDef
Dim db As Database
Set db = CurrentDb

sConnect = \"dBase IV;HDR=NO;IMEX=2;DATABASE=\"
sLocation = \"D:\\Temp\"

Set tdef = db.TableDefs(\"YourTable\")
tdef.Connect = sConnect & sLocation
tdef.RefreshLink

My example has nothing to do with my frist answer.

Når jeg indtaster følgende får jeg kørselsfejl 3170 \"Den installerbare ISAM kan ikke findes\"
Private Sub Kommandoknap244_Click()

Dim sConnect As String
Dim sLocation As String

Dim tdef As TableDef
Dim db As Database
Set db = CurrentDb

sConnect = \"dBaseIV;HDR=NO;IMEX=2;DATABASE=\"
sLocation = \"C:\\Tabel\"

Set tdef = db.TableDefs(\"Tabel_1\")
tdef.Connect = sConnect & sLocation
tdef.RefreshLink

End Sub                                          Mvh TART

OK! The DBASE ISAM dríver needs to be installed. Re-run the setup either for Access or Office Pro version. You should be able to see what is needed.

Til terry
Jeg har prøvet at installerer Access97 igen, men får den samme fejl igen.
Mvh Tart

tart> can you already link or import a DBASE table? If you select the file+get external data + link tables. Can you select DBASE IV from the files of type drop down and import an existing .dbf file? If you can then the dbase drivers are already installed, which means that the problem lies somewhere else.
You can send your database to me and a dBASE file and I will se what I can do. dktebrsa@europe.lego.com

sConnect = \"dBase IV;HDR=NO;IMEX=2;DATABASE=\"

There has to be a space between dBase and IV..

Tak det virker
Tart