Loren McDonald wrote:
Have you done all the office (or at least Access) XP updates? If not,Can't speak for others, but...
it is possible that one of them my resolve your crash problem. I have
been testing Access XP with the same versions of MyODBC and MySQL for a
few weeks now and have yet to see a crash. About the only problem I
have ran into is MySQL shutting down, for no apparent reason, every so
often. I have just installed .55, so I'm waiting to see if it is still
a problem.
I've got the latest MDAC (2.7).
I have tested with Access XP - bare, Service Pack 1 and Service Pack 2.
I have also tried with a few startup switches, eg /safe which was recommended to me by M$ helpdesk.
MyODBC options:
- Don't Optimize Column Width
- Return Matching Rows
- Change BIGINT Columns to INT
Drifting off topic...
Also, not only does the developer version of Access crash, but the deployable, cut-down versions you can make with the packaging wizard also crash similarly.
One stange thing I've noticed is that whereas sometimes Access will crash outright, other times it will simply prevent you from exiting the current record. If you try to either:
- exit the form, or
- move the focus to a sub / parent form, or
- move to another record,
Access will give an error dialog saying that the current action will halt any running code, even though there is no code running. Pressing either the 'End' or 'Debug' buttons results in the same dialog box re-appearing (in modal form). The only thing you can do at this point is to use the task manager to shut down Access.
Also, (nearly finished) the deployable cut-down version, which isn't supposed to have any form / code editing abilities, also gives the 'End' / 'Debug' dialog.
The above problem is another reason why I think the bug is in Access.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
