send to a pass protected db

  • Thread starter peljo via AccessMonster.com
  • Start date
P

peljo via AccessMonster.com

I am exporting all my tables with the folloiwng function:
Public Function ExportAllTablesP(DBName As String, strPassword As String) As
Boolean
' call it so : ExportAllTablesP "C:\be\be.mdb", "secret"
Dim FrontDB As Database, BackDB As Database, Tbl As DAO.TableDef
Set FrontDB = CurrentDb
Set BackDB = OpenDatabase(DBName, True, False, ";PWD=" & strPassword)
For Each Tbl In FrontDB.TableDefs
If Tbl.Attributes = 0 Then
DoCmd.TransferDatabase acExport, "Microsoft Access", BackDB.Name, acTable,
Tbl.Name, Tbl.Name
End If
Next
BackDB.Close
FrontDB.Close
End Function

I need also to export to this database also certain forms and macros.For
example:
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\BE\Lest & Format
(Date, "dd-mm-yyyy") & ".mdb", acForm, "FrmStock", "FrmStock"

Is there any similar function allowing this export ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top