Transferdatabase to password protected db

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

Guest

Hi,
What syntax do I have to use to export a table to a password protected
db using transferdatabase or copyobject or ... with db password, ie
without invoking the password dialog?

Thanks,
Walter
 
forest95 said:
I have the same issue, did you ever find a solution?

Steve
Click to expand...

Hi Steve

The trick is to import and not to export:

Set oAcc = New Access.Application
Set DB = oAcc.DBEngine.OpenDatabase(AktuellesProjekt, _
False, False, ";PWD=" & strProjPW)
oAcc.OpenCurrentDatabase strForeignDB
oAcc.DoCmd.TransferDatabase acImport, "Microsoft Access", _
CurrentProject.FullName, _
acTable, "myTable", "MyTable", True
Set DB = Nothing
Set oAcc = Nothing

Walter
 
nospam said:
Hi Steve

The trick is to import and not to export:

Set oAcc = New Access.Application
Set DB = oAcc.DBEngine.OpenDatabase(AktuellesProjekt, _
False, False, ";PWD=" & strProjPW)
oAcc.OpenCurrentDatabase strForeignDB
oAcc.DoCmd.TransferDatabase acImport, "Microsoft Access", _
CurrentProject.FullName, _
acTable, "myTable", "MyTable", True
Set DB = Nothing
Set oAcc = Nothing

Walter
Click to expand...

The Line
Set DB = oAcc.DBEngine.OpenDatabase(AktuellesProjekt, _
should read
Set DB = oAcc.DBEngine.OpenDatabase(strForeignDB, _

Walter
 
Back
Top