MarkH
lists at theopg.com
Mon Nov 22 12:18:54 CST 2004
Thanks Dan... I have discussed it with the client and it looks like as an interim we will use ADO connections instead of linked tables :@) and then in the long term we will be merging the two workgroups :@))) Thanks again Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: 21 November 2004 16:46 To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Accessing data in secured mdb from another secured mdbona different workgroup Mark, If 'JoeJ' on secured Database A has a PID of 1234, then JoeJ will be able to (programmatically) open and run secured Database B from Database A if there is a JoeJ with PID of 1234 set up for Database B. At one point when I was setting up a few different databases, I made sure that the same people had the same PID's. I never did set up the method to run one from the other though. Best of Luck, Dan Waters ProMation Systems -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MarkH Sent: Wednesday, November 17, 2004 12:06 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Accessing data in secured mdb from another secured mdb ona different workgroup Hello All 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? Thanks in advance Mark --- 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 -- _______________________________________________ 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004