[AccessD] Retrieving data from a secured remote db

Well if the database that needs the data from the secured db is itself going
to be secured, why don't you use the same MDW file to do the security, then
the new db will automatically have rights to the other one. Problem solved.

> -----Original Message-----
> From:	Mcgillivray, Donald [ITS]
> [SMTP:donald.a.Mcgillivray at mail.sprint.com]
> Sent:	Thursday, September 18, 2003 7:04 PM
> To:	Access Developers discussion and problem solving
> Subject:	RE: [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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com