how to link a password protected database? 2

[ide]

I want to link a table.
If the BetetMain.mdb hasn't database password, the

DoCmd.TransferDatabase acLink, "Microsoft Access", _
actPath & "\Betet\BetetMain.mdb", acTable, "Betet", "Betet"

command works.
Otherwise it inputs the correct password and after it does not makes the link to the table.

What can I do?

ide
pls HELP!
8:

 

[Jn88]

Use the TableDef.Connect Method
Look in help
If you don’t get it than let me know I will be happy to help you

Jn88

 

[ide]

pls give more info, how to use it.

Set dm = OpenDatabase(actPath & "\Betet\BetetMain.MDB", False, False, ";PWD=a&quot
Set tdfLinked = dm.TableDefs("Betet&quot

what follows after it?
thank you very much
ide

 

[Jn88]

Dim tdf As TableDef
Dim db As Database

Set db = CurrentDb

set tdf = db.TableDefs("Betet&quot

tdf.Connect = ";database =c:\ejts_data.mdb ;pwd=1414"

tdf.RefreshLink

Hope this helps if not let me know

Jn88

 

[ide]

Jn88,
It's perfect.
Thank you again.
Regars
ide
s-)