auto update linked tables

[Joran]

Hello,

I have linked tables to a Notes Database, if I refresh the contents from the tables by opening them, a notes username is asked. There for I would like to automaticaly update the data eg every hour. Is it possible to schedule this? Is it possible to include a notes username and password?

thanks in advance,

Joran

 

[7ony]

My I suggest 2 possible solutions.
1. When you establish the LINK, there is an option to save your user & password for ODBC sources. That MAY work. Some sources (ODBC Drivers) will still require a User/PW.
2. Connect to your Table using VBA. Means you don't even need the Link. But this requires you be familar w/ connecting to an external datasource using DAO recordsets & ODBC. There are some examples in Access Help. Just key on those keywords.
G'Luck
7ony