Help with Password problem

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
 

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