Hi there
I am using MS Query to return data from a central data base. The database is accessed via a url and a password.
I want users to refresh data either clicking a button on an maybe at predetermined times when the central DB itself is refreshed.
Access to the central DB requires a password. The password dialog box pops up when a refresh is requested. The central DB isn't on a trusted site although it is = probably doesn't have whatever to make it a trusted site.
How do I respond to the password request in VBA. Shell something???
The users aren't password types and the refresh and subsuquent update is intended to happen in the background anyway.
ziggy
I am using MS Query to return data from a central data base. The database is accessed via a url and a password.
I want users to refresh data either clicking a button on an maybe at predetermined times when the central DB itself is refreshed.
Access to the central DB requires a password. The password dialog box pops up when a refresh is requested. The central DB isn't on a trusted site although it is = probably doesn't have whatever to make it a trusted site.
How do I respond to the password request in VBA. Shell something???
The users aren't password types and the refresh and subsuquent update is intended to happen in the background anyway.
ziggy
