linking to a secured database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick B - 29 Apr 2004 14:35 GMT

I have a few databases which need to link to a few tables within a secured
database. I have set the permissions of the secured database to allow the
required rights however, I am unable to link the tables. Any suggestions as
to what I should do or where I can go to find this information?

Thank you in advance,

-rick

Reply to this Message

Rick B - 29 Apr 2004 14:40 GMT

I should probably mention that these database are in Access 2002

> I have a few databases which need to link to a few tables within a secured
> database. I have set the permissions of the secured database to allow the
[quoted text clipped - 4 lines]
>
> -rick

Reply to this Message

Joan Wild - 29 Apr 2004 16:36 GMT

> I have a few databases which need to link to a few tables within a
> secured database. I have set the permissions of the secured database
> to allow the required rights however, I am unable to link the tables.

What rights did you set? If the 'few databases' are unsecured, then you
would need to give the Users Group Open permission on the secured database,
and at least read data on the tables.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

david epsom dot com dot au - 29 Apr 2004 23:28 GMT

When linking from an unsecured to a secured database, you
need to either use the SAME WORKGROUP or different workgroups
with the SAME USERS OR GROUPS. This will enable you to
use owner permission queries or to use permissions granted
in the secured database.

Have you got that worked out already?

(david)

> I have a few databases which need to link to a few tables within a secured
> database. I have set the permissions of the secured database to allow the
[quoted text clipped - 4 lines]
>
> -rick

Reply to this Message