I have a database that has user level security on it. I now need to link to a
table in this database from another database, but it's saying I don't have
permission & I can't find out how to set the permission up.

Can someone let me know what I need to do?

Thanks

Sharon A wrote:
> I have a database that has user level security on it. I now need to
> link to a table in this database from another database, but it's
> saying I don't have permission & I can't find out how to set the
> permission up.
>
> Can someone let me know what I need to do?
>
> Thanks

You cannot link from a non-secure file to a table in a secure one. The
table you want to create the link in needs to be secured with the same
workgroup as the secured one is using.

There are ways via code to retrieve data from a secure file into a
non-secure one providing you know the workgroup file's location and the
credentials for a User in that workgroup, but you cannot create a standard
"link".

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Thanks

"Rick Brandt" wrote:

> Sharon A wrote:
> > I have a database that has user level security on it. I now need to
> > link to a table in this database from another database, but it's
> > saying I don't have permission & I can't find out how to set the
> > permission up.
> >
> > Can someone let me know what I need to do?
> >
> > Thanks
>
> You cannot link from a non-secure file to a table in a secure one. The
> table you want to create the link in needs to be secured with the same
> workgroup as the secured one is using.
>
> There are ways via code to retrieve data from a secure file into a
> non-secure one providing you know the workgroup file's location and the
> credentials for a User in that workgroup, but you cannot create a standard
> "link".
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>