Hi, Mark.
Your home computer's "Compact on Close" setting is checked, while the
computers at work aren't checked. To match the others, open this database
on your home computer. Open your Tools menu and select Options. Select the
"General" tab in the Options dialog window. A little further than half-way
down on the left side is a check box for "Compact on Close." If you uncheck
this box, then the next time you close the database, it won't compact and
ask you for the password when the compaction is done.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
"Mark R" <ma*********@ntlworld.com> wrote in message
news:tQ***************@newsfe1-gui.ntli.net...
Hi all,
This is probably really simple but the answer has eluded me so far. I
have a frontend application which when closed on PC's at work, just closes.
However, when I close it (an exact copy) on my home PC, the forms & database
window close but then prompt for the database password. I can enter the
password or click on cancel and then access will shut down. Is there a
setting or option I am missing on my home PC? I do not have the same problem
with the backend.
Both machines are running XP pro and access 2000.
TIA,
Mark