[AccessD] Accessing data in secured mdb from another secured mdbon a different workgroup

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?

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?

Thanks again

Mark

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bryan
Carbonnell
Sent: 19 November 2004 02:26
To: Access Developers discussion and problemsolving
Subject: Re: [AccessD] Accessing data in secured mdb from another
secured mdbon a different workgroup


On 18 Nov 2004 at 18:28, MarkH wrote:

> Hello All (I sent his yesterday but it didn';t seem to get through...)
> 
> Using AXP on WinXP
> 
> I have two databases secured on different workgroups and accessed from

> different front ends. I need to be able to import data from one into 
> the other but am having problems as they are secured on different 
> mdw's. I could merge the two mdw's but that would be a bit of a pain.
> 
> Anyone know a simple solution?

Create a new DAO workspace

Private mwks As DAO.Workspace 'Workspace for the DB's to be opened in
Private mdbBE As DAO.Database 'BE DB Reference

'Open the Workspace
Set mwks = CreateWorkspace("AnyName", "UserName", "PassWord") 'Set
Reference to BE, opened Exclusively 
Set mdbBE = mwks.OpenDatabase(Me.BEPath, True, False, Me.BEPassword)

Now the mdbBE dao database object can be refered to just like you 
would with any other DAO database object.

This is the approach that we took with the Alpha version of the 
BackEnd Upgrader that deals with back ends that were secured with Jet 
Security.

-- 
Bryan Carbonnell - carbonnb at sympatico.ca
Unfortunately common sense isn't so common!


-- 
_______________________________________________
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