Linking to Secured Access Database with Code

[lewatkin]

Gang,

I need to be able to extract 2 tables from a secured Access database everynight. I know how to pass a username and password programmatically to launch a secured database, but this is a shade different. First, I have to join a different workgroup, pass username and password, then import 2 tables, then close the connection. Any ideas?

Thanks in advance!!

Lee