Linked tables

  • Thread starter Thread starter Sharon A
  • Start date Start date
S

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
 
Sharon said:
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
Click to expand...

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

Rick Brandt said:
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".
Click to expand...
 
Back
Top