Link table from a secured database to another secured database

[wa7ed via AccessMonster.com]

I have two different databases, one is secured by a workgroup file (DB1), the
other is secured by another workgroup file (DB2).
I want a way to enable me to link a table from the first secured DB (DB1) ,
while in the other DB (DB2). and being able to read its data.
DB2 is multiuser system, and I want every user who logsin this DB2 to use a
code that enable him to link this table from DB1 and read its data.
I realy need somebody to help me on this.

 

[TC]

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

 

[wa7ed via AccessMonster.com]

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]

That means that I should create the same number of users with thier same PID
in the two databases!!!

Sure, if you did it the way I describe. But another way would be to
assign permissions to groups, not to usrs. Then you would only need to
have the same /groups/ in the two workgroup files.

coz not only (Fred) is going to access my DB.

I understand that.

also I'm looking for a code to do this not through the link table manager.

I suggest you start by using manual table links. Get the permission
issues correct. /Then/ you cn worry about doing it automatically,
through code. If you can not do it manually, you'll not be able to do
it through code.

In fact, I have been created a user in my secured DB2, similar to the owner
user in the secured DB1.

Not sure what you mean by "similar". Two users (in different workgroup
files) are either identical, or not idential, as far as Access is
concened.

and I could open DB1 without asking for permissions!

Say user Tom exists in WG1 and has permissions to DB1. If you add an
identical user Tom to WG2, ie. a user with username Tom & the same PID,
then, those two Tom's are identical as far as Access is concerned. So
it is absolutely to be expected, that the Tom in WG2, willhave the same
access to DB1, as the Tom in WG1.

my problem now that I can't use the connect command to link to a table in DB1.

Get it going with manual linking first. Then worry about how to do it
through code.

HTH,
TC

 

[wa7ed via AccessMonster.com]

I believe that this is the best solution. I have been tried it and it worked
fine.
but my boss didn't agree on it, coz the first database has been distributed
to users one month back and they started to use it. he said that its too
early to announce for new modifications with the database and the workgroup
file.
He wants me to play with the other database, which is still under developing.
Yesterday we discused in fast, he believes that we can do it by creating a
user in DB2 identical to the owner user in DB1, and use RWOP queries to get
the data from that table. I don't know how he wants me to link it!! I still
have no idea. we may continue discussion today.
Until I know exactly what he wants, I want to thank u very much for ur
assistance.
Regards
Faten