B
Billy B
I have a procedure that is iniated from the frontend db that disconnects the
front end and backend db, creates a backup copy of both and the procedure
works fine. I have the VBA code access passworded in both databases. Below
is the last of the code that is being run. After the last line of the code
runs, I get two dialog boxes asking for the password. I am assuming that is
for the VBA code. Do I need to develop code to supply the password? If so,
how?
Thank you.
Function fBackendBackup(Optional PassPath As String)
On Error Resume Next
'this function runs the funtions in the backend
'database
Dim objAcc As Access.Application
Set objAcc = GetObject(CurrentProject.Path & "\MyProject.mdb")
objAcc.Run "DeleteFile", PassPath
objAcc.Run "fMakeBackup", PassPath
Set objAcc = Nothing
'prompted dialog boxes appear here
End Function
front end and backend db, creates a backup copy of both and the procedure
works fine. I have the VBA code access passworded in both databases. Below
is the last of the code that is being run. After the last line of the code
runs, I get two dialog boxes asking for the password. I am assuming that is
for the VBA code. Do I need to develop code to supply the password? If so,
how?
Thank you.
Function fBackendBackup(Optional PassPath As String)
On Error Resume Next
'this function runs the funtions in the backend
'database
Dim objAcc As Access.Application
Set objAcc = GetObject(CurrentProject.Path & "\MyProject.mdb")
objAcc.Run "DeleteFile", PassPath
objAcc.Run "fMakeBackup", PassPath
Set objAcc = Nothing
'prompted dialog boxes appear here
End Function