Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Lakewood, New Jersey, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 2000 file crashes on Windows 98 (Access 2000 / Windows 98)

    I developed an Access 2000 database on Windows XP using Office XP. It works just fine on Windows XP. When I open it on Windows 98, I get the startup form (frmLogin). I can choose the username, enter the password, and choose the region name (i.e. my front-end does interact with my Access 2000 back-end). However, when I click the login button (which executes code), the database crashes. Has anyone had a similar experience and, can you offer advice?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Access 2000 file crashes on Windows 98 (Access

    Do you get any error messages when it crashes?

    Can you by-pass the login form, by opening the database with the shift key down?

    It is quite possible that there are missing References. If you can get to the VBA Editor, check Tools..References. You may find some with "missing" because the references are set to the ones that apply to the XP machine. If so, delete the reference, then scroll down the list and find the equivalent one from those available.

    What about the path to the back end. Do you have the same path on both machines, or is the data on yet another machine?
    Regards
    John



  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access 2000 file crashes on Windows 98 (Access 2000 / Windows 98)

    Is Office 2000 properly installed on the 98 machine? Are you using anything like the calendar control or the common dialog control? Are you referencing the Office library object? There are a bunch of things that will be different on the 98 machine, and since Office XP uses a different version of ADO than Office 2000, that may be the place to start looking.

    PS/ just because you developed something in 2000 file format doesn't really insure that it is fully compatible with 2000, especially on a different operating system. The references will be to the XP version libraries.
    Charlotte

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access 2000 file crashes on Windows 98 (Access 2000 / Windows 98)

    I've seen this same behavior with reports. What I discovered is that if you open the objects in design mode in 2000 and save them, then the database will work OK. A strange thing related to doing 2000 development using Access 2002.
    Wendell

  5. #5
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Lakewood, New Jersey, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 file crashes on Windows 98 (Access 2000 / Windows 98)

    I realized after posting that I should probably check for missing references. I don't have easy access to do so because it's on my client's machine. What I did when I delivered the application was create a new database on her computer, import all of my objects into it, and reset my options and stuff. It was a pain, but it worked. It's not such a big deal b/c they're supposed to switch over to XP soon and then we'll all be on the same page (sort of). Thanks for all of your suggesions. I just assumed that setting the default file format to Access 2000 will make my database compatible with Office 2000 on Windows 98. But things are never so simple right [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

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