Automate table import with a twist...

[MatsHulten]

Can someone help me out with this one?

I need to automate an import to an Access DB from another system.
Problem is that the other system has a native loginbox that appears whenever I try to access data from it.

Any thoughts how to get around this?

-Mats

 

[MichaelRed]

Assuming you know the "title" of the window, I think you could use some of the API calls to find the 'window' for the popup and then send a message to the window. probably very messy, but should be easy enough after you get the API declarations and calls figured out.

As an alternative, consult w/ the DBA of the database. They may know of a MUCH better soloution.

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over