Database Password prompt when closing application

[kellmich]

Whenever I close one particular application I get prompted for the database
password (MS ACCESS 2007). Has anyone run into this problem that can provide
some insight? I haven't got a clue as to why I would be prompted for this on
exit!

Let me add that I access the database by opening it as a separate instance
of Access through an application object set up in VBA, and in which I set a
password. at that time I supply a password. I also copy a table to the
Application to be loaded into the new instance just before creating that
instance and am prompted for the database password at that time. Here is a
code sample (The code functions as intended):

Set appAccess = CreateObject("Access.Application")
DoCmd.CopyObject "c:\Admin.accdb", Me.txtID.Value, acTable, Me.txtID.Value
appAccess.OpenCurrentDatabase "c:\Admin.accdb", , "password"

I don't know that this code is causing the problem, but it is the only place
I am dealing with the password for the database I'm opening. That database
does have a VBA password also but my problem is occurring on exit from the
application not while attempting to work with vba code.

 

[boblarson]

Do you have the database set to compact on close? That could possibly be
causing the problem.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com

__________________________________

 

[kellmich]

No I don't. This is a static application as to size. It actually is a front
end with almost zero data of its own. It remotely accesses other data
through ADO. Even the table it copies over to another DB is one record with
one field in it that is a few characters of text.