auto update linked tables
auto update linked tables
(OP)
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
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
RE: auto update linked tables
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