Copy Table to Another Database (VBA)-- What if the another Database has a password? How can I include the password?

[JohneX]

This Code is from Mr. Boblarson:

Dim objAcc as Object
Dim objAcc2 As Object

Set objAcc = New Access.Application
objAcc.OpenCurrentDatabase("C:\FilePathandNameHere.accdb")


objAcc.DoCmd.CopyObject "D:\AnotherFilePathAndNameHere.accdb", , acTable,"SourceTableNameHere"

objAcc.CloseCurrentDatabase

Set objAcc = Nothing

 

[Micron]

I've never used that method but from what I know of it, it opens the db in the Access application window and then it becomes the active database, in which case I don't see how that will work. The method is meant for opening a db from another COM application, such as Excel. M$ even mentions closing the current db window before doing this. Perhaps from the db that contains the table

SELECT * INTO Table1 IN '' [MS Access;PWD=PasswordHere;DATABASE=C:\....\dbNameHere.mdb]
FROM Table2

or

SELECT * INTO [";PWD=PasswordHere;DATABASE=C:\....\dbNameHere.mdb"].table1 FROM table2

 

[JohneX]

Thank you! Sir.

 

[Micron]

You're welcome. Care to let us know what worked?

 

[JohneX]

 

[JohneX]

View attachment 25176