All I want to do is COPY (using DoCmd.CopyObject OR DoCmd.TransferDatabase) some queries and reports from one SECURED database to another SECURED database in the BACKGROUND (unseen by the user) under control of our VB6 Application.
We are using databases which are secured by a Workgroup .mdw file, together with a hierarchy of UserIDs and User passwords. The databases also have a DATABASE password. Hence we must pass all of these BEFORE we can use .OpenCurrentDatabase (after opening a new instance of ACCESS by specifying New Access.Application.
So my questions are:
HOW do we specify
1. The specific workgroup .mdw file?
2. The UserID and User password
3. The DATABASE password.
(We CAN do this OK by combining them into a ConnectionString when opening a RECORDSET – but this does NOT allow us to manipulate QUERIES and REPORTS. )
i.e. We must be able to use .DoCmd – but on a series of SECURED databases.
ALL HELP IS MUCH APPRECIATED.
Kelvin