Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SP 2 Crashes (2003/SP2)

    Has anyone found any work arounds to these problems that seem to make Access 2003 SP1 and especially SP2 crash?

    1) MySql linked tables. After you install SP2 and try Get External Data->Link tables to link to a MySql server Access crashes.
    2) Having an Access .mdb or .mdb utilites file (only contains module code) as a reference. ie. Create a new blank file, reference another db file (mde or mdb), open the VBA code window, close it and compact; Access crashes.
    3) Parent/Child forms. Create a form with a tab control with three tabs, put a child form on tabs 2 and 3, open the form and select tab 2 or 3 and Access crashes!

    Has anyone found a work around to any of these problems?

    One sec! A solution to 1) you have to replace the WindowsSystem32msjet40.dll ver 9025 with 8618 and I can again create new or update MySQL links! Yay!
    So can anyone help with 2 and 3?

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SP 2 Crashes (2003/SP2)

    Do you have any Rowsource changes for list boxes or combo boxes in code?

    I got bitten by this when I went up to 2003 (see <post#=480,803)>post 480,803)</post#>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    New Lounger
    Join Date
    Dec 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SP 2 Crashes (2003/SP2)

    Actually I do in other places of code so I'll have to check that as well.

    Thanks.

  4. #4
    New Lounger
    Join Date
    Dec 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SP 2 Crashes (2003/SP2)

    Actually I just created a test case for this but I didn't get the crash. Attached is the test app. Am I doing something different to avoid the crash?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •