MarkH
lists at theopg.com
Fri Nov 19 04:47:54 CST 2004
No worries matey... Used ADO and it works just fine :@) Thanks anyway Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bryan Carbonnell Sent: 19 November 2004 10:31 To: Access Developers discussion and problemsolving Subject: RE: [AccessD] Accessing data in secured mdb from anothersecured mdbon a different workgroup On 19 Nov 2004 at 9:17, MarkH wrote: > Hello Bryan... Thanks for the suggestion, not quite sure on a couple > of things though... > > I assume that, from "me.BEPassword" the user enters their username and > password on screen? It could be that they do do that. We had it hardcoded. but that is a password for the BE if it only has a password on it, not Jet security, just a password. > I'm not sure how this gets passed the mdw security? The front-end that > is requesting the data belongs to a different mdw so even though I > passed the correct username and password I still get refused access > because the connection request is being made whilst joined to a > different mdw. I have tried specifying the mdw in the connection > string but either its not possible or I'm getting the format wrong :@( > > Is it possible to specify a different mdw? Aw cr*p. Missed that part completely :( I'm not sure. -- Bryan Carbonnell - carbonnb at sympatico.ca Code so clean...you can eat off it. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.769 / Virus Database: 516 - Release Date: 24/09/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.769 / Virus Database: 516 - Release Date: 24/09/2004