Ændring i MSysObejcts

No you cant

If all you want to do is change the location of your database+tables then look at this (Access 97)

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


Set tdef = db.TableDefs(\"tblLinked\")
tdef.Connect = \";DATABASE=C:\\SomePath\\TheLinked.mdb\"
tdef.RefreshLink

Set tdef = Nothing
Set db = Nothing

This just shows you how to change the location, it doesnt tell you where you should have the database+table information. I suggest that it is in the registry, it cant be in the backend database because that might move and it cant be in the fronted because thats mnaybe on many PC\'s

>Terry
Det er jo fantastisk. Der virker perfekt og opdater automatisk MSysObjects med det nye link.

:o)