jeffrey.demulling at usbank.com
jeffrey.demulling at usbank.com
Thu Apr 15 15:03:23 CDT 2004
I have the following code in a database. Works fine if there is no password on the database. However I need to add a password to the database the is being linked to. How can I modify the code so that it accepts a password and does not prompt the user for one? Sub linkdatatable(mytable As String) 'Link in tables for query If IsLinked(mytable) = False Then DoCmd.TransferDatabase acLink, "Microsoft Access", GetDataFile, acTable, mytable, mytable, False End If End Sub TIA