Security Problem When Linking Tables

[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

 

[K8Gardner]

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