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

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

TC wrote:
>> 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

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

Relevant Pages

  • 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 ... > and I could open DB1 without asking for permissions! ... Say user Tom exists in WG1 and has permissions to DB1. ...
    (microsoft.public.access.security)
  • Re: import security definitions
    ... Now I want to transfer the security permissions - If I open DB1 as administrator and try to transfer - I get an error message that I do not ... Use Access MVP's Sandra Daigle's and Jeff Conrad's DBUtilities utility to copy the permissions from the old database to the new database. ...
    (microsoft.public.access.security)
  • Re: import security definitions
    ... If I use the Access ADD-In I can only select a source and a target DB - I can not select a table to copy the permissions to.. ... Open the permissions table and change 'Administrator' to 'xy'. ... Now I want to transfer the security permissions - If I open DB1 as administrator and try to transfer - I get an error message that I do not have permissions on DB2 - If i open DB2 with my workgroup file and user "xy" I get the message that I do not have permissions to DB1. ... Use Access MVP's Sandra Daigle's and Jeff Conrad's DBUtilities utility to copy the permissions from the old database to the new database. ...
    (microsoft.public.access.security)
  • Re: Keep it alive
    ... Sub OpenPasswordProtectedDB() ... TSI SOON database add-in ... another db (let's call it db1), display the application window to the ... Because the database object is closed as soon as the memory used by db1 ...
    (microsoft.public.access.formscoding)
  • Re: Are all records retrieved
    ... the last record in DB1 and navigated to the same last record in Db2 I ... the last record in Db2 which is being displayed from memory. ... Find methods or the Seek method, when the underlying Recordset contains ... last record it is retrieving this from the database thus showing me ...
    (comp.databases.ms-access)