Re: Link table from a secured database to another secured database

That means that I should create the same number of users with thier same PID
in the two databases!!!
coz not only (Fred) is going to access my DB.
also I'm looking for a code to do this not through the link table manager.
In fact, I have been created a user in my secured DB2, similar to the owner
user in the secured DB1. and I could open DB1 without asking for permissions!
my problem now that I can't use the connect command to link to a table in DB1.

Do u have other ideas that may help.
Thank You.

TC wrote:
>So you have DB1, secured by WG1 - and DB2, secured by WG2.
>
>User Fred, in WG2, opens DB2.
>
>You want Fred to be able to link to tables in DB1.
>
>Correct?
>
>If so, I'd suggest this. This is off the top of my head & I have not
>tested it.
>
>Be careful to use WG*1* or WG*2* exactly as I have stated below.
>
>1. Create user Fred, in WG1, with exactly the same username and
>Personal Identifier (PID) that you used when you origially created him
>in WG2. (Now, Fred is known to /both/ workgroup files - not just WG2.)
>
>2. Give user Fred, in WG1, a random password. This stops Fred
>logging-in to WG1. (So Fred does exist in WG1, but he can't /log in/ to
>WG1.)
>
>3. Now select WG1, open DB1, and give Fred whatever permissions you
>want to give him to the tables in DB1.
>
>4. Now select WG2 and open DB2. At this point, Fred should have
>whatever access, to the tables in DB1, that you granted him in step 3.
>
>The key to this, is understnding that if you have two users, each with
>the same username, /and PID/, in several different workgroup files, all
>those users are /indisitinguishable/ to Access, when it works out their
>permissions.
>
>This is all fairly tricky & you would have to do it all just right.
>
>HTH,
>TC

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200512/1
.