Batch File Password for Linked Table

[Bunting]

I'm trying to write a batch file command to run an Access macro. The Access database itself is not password protected so the command opens it. However the macro involves linked tables from a database which is password protected so I need to include log-on details for it. Can anyone tell me how to do this? So far I have

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "L:\Reporting\Report\Data.mdb" /x QueryMacro

I have tried adding the /pwd command but this assumes the password is for the Access database.

 

[PaulBricker]

Can you store the login information directly in the macro? For example, with the TransferDatabase action, you can input ODBC info including the password. Or you could call a function with the macro that uses a connect string to connect to the linked tables.

Paul

 

[jrbarnett]

This thread: thread1121-1404753 includes details of how to create a linked table with embedded connection strings.

John