Advertisement

12.13.2006 at 05:14AM PST, ID: 22091763
[x]
Attachment Details

How to pass a LOGIN and PASSWORD to an external system whose tables I'm linking to; Code runs ON OPEN; DB opens via Task Scheduler (which already requires a login for the workstation).

Asked by bjelen in Microsoft Access Database

The database I'm working with opens each morning at 6:00 am via Task Scheduler. The ON OPEN event of the main form runs a series of queries that pulls student information from a proprietary school district database that I've linked to. That systems requires logging in with a user name and password.

As soon as the first query that uses a linked table is accessed the district system prompts for a password (my login name is already entered).

How can I have my code enter the password? (I tried SENDKEYS, but with no luck.)Start Free Trial
[+][-]12.13.2006 at 05:19AM PST, ID: 18130138

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.13.2006 at 06:17AM PST, ID: 18130552

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Sign Up Now!
Solution Provided By: jefftwilley
Participating Experts: 3
Solution Grade: A
 
 
[+][-]12.13.2006 at 06:31AM PST, ID: 18130653

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.15.2006 at 11:28AM PST, ID: 18148343

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.14.2007 at 06:49PM PDT, ID: 19696779

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32