MDW and linked tables

[afleet]

Folks,
I have a successfully secured MDB file (lets call DB A), which I would
like an unsecured database (DB B) to be able to link to. I don't care
about security in DB B, and the link should be Read Only. I assume that
the link would be trying to connect to DB A as Admin (which has
read-only privs on the tables).

Is this possible? Do both databases need to be secured?

When I try to create the link, I get the error "You don't have
permission to import, export, or link to 'tablename... you must have
Read Design and Read Data permissions for it.. etc

All my users in DB A have these permissions, and also Open/Run on
database.

If the DB2 is connecting as Admin, then it would need to supply the new
Admin password. How can I do this? (or, can I specify a different
user/password for the link - ala a database link concept in Oracle?)

Do I have to write some code?

Thanks in advance, for any pointers you can give me.

Adam.

 

[Joan Wild]

If you grant the Users Group in DB A, permission to Open the database
object, and read data permissions on the table(s), then DB B will be able to
link to them.

 

[afleet]

Thanks Joan, but unfortunately I already have that. It makes no
difference, still get the error mentioned above. Any more thoughts?

Thanks,

Adam.

 

[jacksonmacd]

Folks,
I have a successfully secured MDB file (lets call DB A), which I would
like an unsecured database (DB B) to be able to link to. I don't care
about security in DB B, and the link should be Read Only. I assume that
the link would be trying to connect to DB A as Admin (which has
read-only privs on the tables).

Is this possible? Do both databases need to be secured?

It's the Access session that determines the current user, not the
database that you've opened. Therefore, your assumption that the link
would be connected as Admin may be incorrect. Whatever user is
currently running in DB B is the what will be used to connect to DB A.
It would be Admin only if Admin was currently running DB B.

 

[Joan Wild]

You need to try it again. Permissions are stored in the mdb file. If you
grant the Users Group read data permission and open database permission in
the secured mdb, they'll be able to open and read from the unsecured mdb.