Cannot use DoCmd.TransferDatabase with system.mdw secured SourceDB

[Michael P. Schieferer]

Hello there,

following problem: I have two Access Databases. One secured with an
additional system.mdw (NOT the system-wide but another) wich actually
holds the Data and another unsecured one.

Now I want to create Tablelinks in the unsecured DB. I use the
DoCmd.TransferDatabase command to realize this. But I'm having realy big
trouble getting the Tablelinks. I cant get it work to create the
Tablelinks as long the secured DB is secured with the system.mdw.

I tried it in VBA Code with "Microsoft Access", "Jet 3.x" and "ODBC" as
Datasource but no success.

And no, using the system.mdw as my System-wide system.mdw is no
practicable solution for this case.

I'm searching for a long time but could't find any solutions...

Many thanks for your help
Michael P. Schieferer

 

[corey lawson]

Hello there,

following problem: I have two Access Databases. One secured with an
additional system.mdw (NOT the system-wide but another) wich actually
holds the Data and another unsecured one.

Now I want to create Tablelinks in the unsecured DB. I use the
DoCmd.TransferDatabase command to realize this. But I'm having realy big
trouble getting the Tablelinks. I cant get it work to create the
Tablelinks as long the secured DB is secured with the system.mdw.

I tried it in VBA Code with "Microsoft Access", "Jet 3.x" and "ODBC" as
Datasource but no success.

And no, using the system.mdw as my System-wide system.mdw is no
practicable solution for this case.

I'm searching for a long time but could't find any solutions...

Many thanks for your help
Michael P. Schieferer

Try adding the Admin user back into the Admins group for the secured
MDB. Then you should be able to do it. Take it out when you're done, and
make sure that the Admin user has select privs on the objects it needs
ot be able to read. Then the unsecured client (using system.mdw) will be
able to access what it's linked to.

 

[Michael P. Schieferer]

Try adding the Admin user back into the Admins group for the secured
MDB. Then you should be able to do it. Take it out when you're done, and
make sure that the Admin user has select privs on the objects it needs
ot be able to read. Then the unsecured client (using system.mdw) will be
able to access what it's linked to.

Hello,

Changes on the secured MDB and the secure.mdw are not possible. I have
to develop a workaround for an Application which is already released.

Regards
Michael

 

[Joan Wild]

Changes on the secured MDB and the secure.mdw are not possible. I have to
develop a workaround for an Application which is already released.

If I understood your question, you have an unsecured database and you want
to link to tables in a secured database.

See item 46 in the security FAQ.
How can I open a databasein code that was secured using another workgroup
file?

http://support.microsoft.com/?id=207793