Export tables to protected database using Macro

P

Priya

I am trying to export a table to another password
protected database using a Macro. Password is asked. Upon
entering the correct password, there is no error message
but 2nd database doesn't contain the table.
If I unset the password protection in the second database,
the macro and export works fine.

How do I export a table to another database(which is
password protected) successfully ?
Any help is highly appreciated.

Thanks
Priya
 
Top