Bug #2877
closedAccess 2007 issues
0%
Description
This bug is a tracking bug for Access 2007 issues in the entry tool and access in general.
1) seems to ask twice if you are sure you want to exit sometimes.
2) Need to minimize ribbon if it exists
3) Compact and Repair goes via a different pathway.
Updated by Michael Lee about 17 years ago
Private Function minimizeAcc2007Ribbon()
If Application.version >= 12 Then
'do stuff for Access 2007
'tell them about trust centre
'tell them to minimize ribbon Ctrl-F1
End If
End Function
Updated by Michael Lee almost 17 years ago
Different method for turning off confirmation messages. How does one do this?
Updated by Michael Lee over 16 years ago
If turning off confirmation messages doesn't work in Access 2007, this is really important for next release, as contractors will start having Access 2007, perhaps.
Updated by Michael Lee over 16 years ago
Turning off confirmation messages works for Access 2007 as is. Tested today on Ctenium: Vista Enterprise/Access 2007
Updated by Michael Lee over 16 years ago
Compact and Repair now tells you what to do in Access 2007, which is fine. No errors or anything.
Updated by Michael Lee over 16 years ago
Added link to entry tool for access 2007:
http://cvs.bio.unc.edu/protocol/entry-tool-doc/entry-tool-access2007.html
and general options for checking version and incompatibilities, v224_p0321_mid2
Updated by Michael Lee over 16 years ago
The security center is also an issue, and I've added this to the documentation.
Updated by Michael Lee over 16 years ago
Compact and Repair fails when development mode is off. This may apply only to Access2007 or it may be more widespread.
Updated by Michael Lee over 16 years ago
(In reply to comment #8)
Compact and Repair fails when development mode is off. This may apply only to
Access2007 or it may be more widespread.
This is not a problem in Access 2003. Confirming with Access 2007.
Updated by Michael Lee over 16 years ago
Confirmed as a bug. Interestingly, I noticed that Access2003 compacted a DB from 60MB to 40MB. Access2007 compacted it to 25MB. Perhaps I should compact the copy of record in Access2007.
Updated by Michael Lee over 16 years ago
The twice asking user for confirmation has to do with the unload event firing twice. If the application.quit is called from the close event, it doesn't fire twice, or at least doesn't ask you twice to close the database.
Updated by Michael Lee over 16 years ago
I fixed the not asking you twice about exiting and now compact and repair generally works (not if plot data form is open, though, as its closing routines must get cancelled and the whole application barfs).
I think I need a compact mode that will close up all forms before compacting and repairing. Then when opening back up, it needs to not quit as it does in Access2007 only.
Updated by Michael Lee over 16 years ago
Access 2007 now functions normally. Messages about confirmations moved to a portion on the main menu with a link to the other form, rather than that form opening when database starts. Database no longer asks twice if you want to quit, also no longer asks you if you want to quit just after you compact and repair and it reopens. Database no longer crashes when plotdata form is open and dirty, with selectedPlot just changed.
All of this in version:
v224_p0585_mid5
BIG SIGH OF RELIEF!