If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Password prompt on Exit of database
I have a password protected database that is set to Compact & Repair on
Close, and when we upgraded from Access 2003 to Access 2007 it started asking for a password when we close. It will not take the password for the database, but if you choose "Cancel" it closes. I don't think it is compacting though. How can I make it stop asking for the password....or at least make it accept the password that lets me in the database? Thanks!! Susan |
#2
|
|||
|
|||
Password prompt on Exit of database
If you database is properly split, daily compacting is unnecessary unless
you are dealing with lots of data in temporary tables. In fact, compact on close will occasionally cause corruption. Depending upon the number of users, I'd compact the back-end weekly to monthly, and the front-end on the same schedule. Compact on close does not compact the back-end (data) on the server, and that's still necessary. If the database is frequently used for temporary data, it is just as easy to download a copy of the already linked front-end from the server every morning, as to compact it. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Susan" wrote in message ... I have a password protected database that is set to Compact & Repair on Close, and when we upgraded from Access 2003 to Access 2007 it started asking for a password when we close. It will not take the password for the database, but if you choose "Cancel" it closes. I don't think it is compacting though. How can I make it stop asking for the password....or at least make it accept the password that lets me in the database? Thanks!! Susan |
Thread Tools | |
Display Modes | |
|
|