Project

General

Profile

Bug #2877

Access 2007 issues

Added by Michael Lee over 12 years ago. Updated over 11 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
EntryDB
Target version:
Start date:
06/20/2007
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2877

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.

History

#1 Updated by Michael Lee over 12 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

#2 Updated by Michael Lee about 12 years ago

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

#3 Updated by Michael Lee over 11 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.

#4 Updated by Michael Lee over 11 years ago

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

#5 Updated by Michael Lee over 11 years ago

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

#6 Updated by Michael Lee over 11 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

#7 Updated by Michael Lee over 11 years ago

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

#8 Updated by Michael Lee over 11 years ago

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

#9 Updated by Michael Lee over 11 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.

#10 Updated by Michael Lee over 11 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.

#11 Updated by Michael Lee over 11 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.

#12 Updated by Michael Lee over 11 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.

#13 Updated by Michael Lee over 11 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!

#14 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 2877

Also available in: Atom PDF