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

 

[Chris O'C via AccessMonster.com]

There was a bug in Access 97 that caused these symptoms. Fixed it in a
service pack I believe. If you're not using Access 97, either you aren't
joined to the workgroup used to secure the db with the table you want to link
to, or your user doesn't have read design permissions on that table.

Verify you're joined to the workgroup as the user you think you are by
pushing ctrl+g to open the immediate window and paste these commands:

?currentuser()
?syscmd(acSysCmdGetWorkgroupFile)

If your db was split with a copy of the front end on each user's desktop
(forms, queries, reports, links to tables, etc.) and the back end (tables and
relationships only) on the network, you wouldn't have to kick users out of
the db to add table links.

Chris

 

[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

 

[Chris O'C via AccessMonster.com]

If you're using Access 97 install all the service packs. Please let me know
if you need the links.

If you're not using Access 97 open the main db and paste this command in the
immediate window and push the enter key:

?currentuser()

You should get your user name. Paste this command in the immediate window
and push the enter key:

?syscmd(acSysCmdGetWorkgroupFile)

You should get the path to your mdw file.

Open the secondary db and paste the same commands, one at a time. Do the
results match *exactly* in both dbs?

If they do your user doesn't have read design permissions on the tables
Access says you need read design permissions. Sign in as the db owner or a
member of the admins group and give this user read design and read data
permissions.

If they don't you need to sign in with the same user name and workgroup for
both dbs.

Chris