[AccessD] Retrieving data from a secured remote db

Don,

Buried somewhere in Access help is some instruction on this.  For someone
who is logged into one db that has user security to open another db with
user security, that person must have the same User Name and PID in both
systems.  This will avoid requiring the log in to the 2nd db.  Once into the
2nd db, that person can do whatever the 2nd db's permissions allow.  I
tested this once to be sure, and it did work.  

I don't remember exactly how to open one db from another, but I believe it
was just a matter of automation, and there is a lot of help available on
that.

Hope this helps!
Dan Waters

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mcgillivray,
Donald [ITS]
Sent: Thursday, September 18, 2003 3:45 PM
To: AccessD
Subject: [AccessD] Retrieving data from a secured remote db


Hello, All

I'm building a system that needs data from another Access db.  The remote db
is secured using user-level security, and I had hoped to be able to get data
out of it without forcing a login to its workgroup. Not that it's out of the
question, just that I'd rather not if I can avoid it.  My first thought was
to write a procedure that connects to the remote source, gets the needed
data, and pushes it into a temporary table.  Then I can do what I want with
the data until it's time to purge and refresh it again.

My initial experiments have been unsuccessful, but I'm not sure I understand
the available methods to do such a thing.  I've searched the help, and
cannot find a reference to any techniques for passing a username and
password to a remote db.  I've found references to doing so using an ODBC
connected data source, but not a Jet one.

So, is it possible to do what I want?  Or am I going to have to route users
of the new system through the workgroup of the remote one if I want to make
the data available?  Any examples, tips or references to helpful resources
will be greatly appreciated.

Thanks!

Don McGillivray
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com