InfoVeg

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

Different method for turning off confirmation messages. How does one do this?

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.

Turning off confirmation messages works for Access 2007 as is. Tested today on Ctenium: Vista Enterprise/Access 2007

Compact and Repair now tells you what to do in Access 2007, which is fine. No errors or anything.

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

The security center is also an issue, and I've added this to the documentation.

Compact and Repair fails when development mode is off. This may apply only to Access2007 or it may be more widespread.

(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.

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.

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.

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.

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!

Original Bugzilla ID was 2877