Transfer Data - 2 Secured Databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two databases secured by different workgroup files, and I am trying to
figure out a way to import and/or append some data from database A to a table
in database B.

I''ve read prior threads about unsecring the files and resecuring them with
the same workgourp file, but the conversations suggested that you had to
"Join" that new work group, and that this would affect all other databases.
We use a number of databases that are unsecured, so I don't think this
solution will fit.

Among many other things I've tried coding for DoCmd.TransferDatabase, but it
does not seem to accept a workgroup file path or username/password.

Any suggestions would be greatly appreciated.

(Posted to Forms Coding Group as well).
 
Scottam said:
I have two databases secured by different workgroup files, and I am trying
to
figure out a way to import and/or append some data from database A to a
table
in database B.

I''ve read prior threads about unsecring the files and resecuring them
with
the same workgourp file, but the conversations suggested that you had to
"Join" that new work group, and that this would affect all other
databases.
We use a number of databases that are unsecured, so I don't think this
solution will fit.
Click to expand...

You should only join your custom workgroup at runtime, thus not affecting
your unsecured apps. Go ahead and use a common WIF.
Among many other things I've tried coding for DoCmd.TransferDatabase, but
it
does not seem to accept a workgroup file path or username/password.

Any suggestions would be greatly appreciated.

(Posted to Forms Coding Group as well).
Click to expand...

This is evil and must be stopped! Multi-posting bad, cross-posting good.

Regards,
Keith.
www.keithwilby.com
 
Thanks Keith, I'll give that a try.

Keith Wilby said:
You should only join your custom workgroup at runtime, thus not affecting
your unsecured apps. Go ahead and use a common WIF.


This is evil and must be stopped! Multi-posting bad, cross-posting good.

Regards,
Keith.
www.keithwilby.com
Click to expand...
 
You can accomplish this with the two separate workgroup files.

You just need to ensure that there is a group and or user that is common to
both.

You just create the exact same group (using the same PID), in both mdw
files. Grant that group the necessary permissions and anyone in the group
can access either database using either mdw.
 
Back
Top