Security Problem When Linking Tables

  • Thread starter Thread starter K8Gardner
  • Start date Start date
K

K8Gardner

I've designed two databases. One is my main database that one group uses and
the other is a satellite database that has a couple of links to tables in the
main database. I had no problems linking the tables before I opened it up to
the users, but now I'm having a problem linking a new table to the satellite
database. Each time I try to link the tables I get an error message stating
that I do not have the correct security settings. To be specific, it claims
that I do not have have "Read Design" and "Read Data" permission. I've
checked the security settings in both databases and I have full Admin
permissions so I'm not sure what is causing the problem here.

I have also kicked everyone out of the database and I have had exclusive
access to the database when I have tried to link the tables.

Please let me know if anyone has any thoughts on why this is happening.

Thanks,
Kate
 
Thanks for your response Chris.

Regardless of whether or not people are in the database I am unable to link
to tables in the main database from the secondary database. I am, however,
able to link to the secondary database from the main database.

Any advice on how to fix that?

Thanks,
Kate
 
Back
Top