2 Secure MDB require link

[mswilson16]

I have a database that stored personal information. This database is secured using a workgroup. I have another database that stores time information about each person, this database is also secured via a workgroup.

I need to link a table from the personal information database to the time database. When I try doing so I get a access denied message. I tried entering the time database using the Personal information workgroup but then I can not enter that database. Can anyone tell me how to link to secure databases????

thanks in advance

 

[psemianonymous]

You basically don't. The only way to link two secure databases is to start with a common workgroup (.MDW) file. Otherwise, the only way to link them is to give permissions to the Users group, which in effect de-secures whichever table you're giving Users permissions to.

What I'm saying is that to link to a table, you need to be able to share a common group. The only way to do this is to use the universal group ("Users&quot or to use a custom group, and this can only be done if you use the same .MDW file to secure both databases.

So the short answer is "impossible without significant re-work, or significant insecurity."

Good luck,


Pete