CopyObject from Passworded Databae

[wrstanley]

I am trying to use DoCmd.CopyObject to copy a table from a database tha
has a database password. After the path to the databse, I've trie
adding:

;Database Password=MyPassword and
;PWD=MyPassword

Neither work.

Search of the Internet and Microsoft Knowledge Base were fruitless.

I'd appreciate any help

 

[Alex Dybenko]

Hi,
I would try to open other mdb in another access instance using
CreateObject() and then try to run DoCmd.CopyObject

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[wrstanley]

Thank you for the reply, but there must be a straightforward way i
which to access a password protected database and copy a table

 

[Alex Dybenko]

Have a look here:
http://alexdyb.blogspot.com/2006/04/how-to-export-objects-to-secured.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com