TransferDatabase with Secure mdb

[Kahuna]

I believe it's possible to use the TransferDatabase to link a table in a
secure mdb. Works great when the person doing the linking (opening the main
App which links automatically) is logged in with a high level password, but
I'd like to allow lower level - non-admin log ons to also create the link.
Once linked I have a RWOP query to read & write the data.

How do I set the security to do that

Cheers IA

 

[Kahuna]

Sorry folks - on re reading this message I realised my problem is a little
different than I made it sound!

Actually I can set the permissions to link to the secure mdb but it seems I
have to let the user have 'read design' rights to the secure mdb in order to
allow them insert,update,delete, read data permissions. I'd like to enable
them to link using the TransferDatabase then exclude them from viewing the
structure of the secure mdb. I guess that means revoking ReadDesign rights?
But how?

Help appreciated.

 

[TC]

You can not read from or write to a table unless you have Read Design. Jet
needs that permission in order to read the design of the table in order to
work out what are the fields, etc. No Read Design - no access to table!

If you want any user to be able to read certain data from the secured
database, how about creating a Run With Owner Permission (RWOP) query in the
secured database? Give the standard Admin user, access to that query. Then,
Admin has no direct access to any tables in the secured database, but >can<
access whatever data is provided by the RWOP query.

HTH,
TC

 

[Kahuna]

Thanks TC - SecFaq to the rescue again with .Connect and no access
permissins required.

Thanks all.