[AccessD] A2K2 Set Link in Code for Database with Password

Hi Steve

You should have a look at the TableDefs collection and the Connect
property. This is the way to go and will work faster too.

If you look up the archive on "relink" you should find several
examples.

/gustav


> Using this type of line to link a table in BE to a front end app:

> DoCmd.TransferDatabase acLink, "Microsoft Access", _
>        <path to mdb>, acTable, _
>         rs(0), rs(0), False, True

> How do I supply a password (mdb password, not using mdw) in this line so
> the user is not prompted for it?

> TIA
> Steve