[AccessD] Retrieving data from a secured remote db

Thanks, Drew

Well, either linking or grabbing the data - makes little difference to
me.  I'm planning to secure the new db, in case that complicates your
first scenario any.  Don't really like the idea of enabling the Admin
account if I can avoid it.

Can you point me in the direction of establishing a connection via code?
Been studying the help(less) and don't see an example for what I'm aimed
at.

Thanks!
Don

-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com] 
Sent: Thursday, September 18, 2003 3:19 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Retrieving data from a secured remote db


Okay, and you just want to retrieve data from it?  Do you want a linked
table, or not? If you have a table, that you want to allow access to,
you should be able to set read permissions on a table, for the Admin
account, which is the 'default' account used for unsecure databases.
You'll have to give the admin account permissions to open the database
too.

If you don't want to go that route, with linking a table, you could just
use ADO/DAO code, to connect to the db using the appropriate .mdw file,
to retrieve the data (the unbound method)! grin.  Of course this would
put the account and password in the source, so you would probably want
to restrict access to the source (.mde).

Drew

-----Original Message-----
From: Mcgillivray, Donald [ITS]
[mailto:donald.a.Mcgillivray at mail.sprint.com]
Sent: Thursday, September 18, 2003 5:05 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Retrieving data from a secured remote db


Drew,

It's just an .mdb on a network drive.

Don

-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com] 
Sent: Thursday, September 18, 2003 2:54 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Retrieving data from a secured remote db


What exactly do you mean by remote?  Are we talking about an .mdb on a
network drive, or are we talking about an .mdb somewhere on the
internet?

Drew

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