Linked tables

[Sharon A]

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

 

[Rick Brandt]

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".

 

[Sharon A]

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".