Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Location
    New York, New York, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problem moving Access 97 app to newer versions (97 Sr-2)

    I have an Access 97 application that uses an Oracle 8i database as the back end. The Oracle database is being accessed via Oracle ODBC drivers. The Oracle tables are linked in the Access application. I want to move this application into Access 2000 and Access 2002 (XP). After opened the application in Access 2000 and converting it, everything was okay until Access attempted to update the Oracle database via a form bound to a datasheet. The datasheet displays the table records okay. After updating data in an existing records or adding a new record then moving off the record to initiate a table update, Access 2000 crashes with an General Protection Fault. It does not give any error messages. When restarting the application and again viewing the Oracle data with the form, the record added is there or a changes was performed. I cannot figure out why this is happening because I cannot trap an error within Access. Whatever mechanism that controls the Oracle table update must be external to Access 2000. Has anyone had experience converting Access 97 applicatons to newer versions? Is the a definitive guide for the conversion process that describes the pitfalls? I'm at a loss and need to figure this out ASAP. Please HELP!!!

  2. #2
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem moving Access 97 app to newer versions (97 Sr-2)

    I've updated 97 db's to xp but not with links to oracle but sql server. I would recommend getting the latest odbc drivers for oracle and try deleting and recreating the links to the oracle tables.

  3. #3
    New Lounger
    Join Date
    Feb 2003
    Location
    New York, New York, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem moving Access 97 app to newer versions (97 Sr-2)

    Thanks for the suggestion but I've been there, done that. Didn't help. Someone suggested using the Microsoft Oracle ODBC driver instead of the Oracle ODBC driver. It's a no-no in my company to use anything other than the Oracle ODBC drivers. However, I tried the Microsoft driver anyway and the problem still occured.

  4. #4
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem moving Access 97 app to newer versions (97 Sr-2)

    What if you create a new db in 2000 and link to oracle tables and update them. Does it happen then?

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

    Re: Problem moving Access 97 app to newer versions (97 Sr-2)

    You aren't mixing DAO and ADO in the same routine are you? That is a guaranteed crash.
    Charlotte

  6. #6
    New Lounger
    Join Date
    Feb 2003
    Location
    New York, New York, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem moving Access 97 app to newer versions (97 Sr-2)

    The problem is not occurring in code created by me. It is happening within the Access internals that perform updates to Linked tables. That's why I'm having such trouble figuring out what is going wrong. It is out of my control.

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

    Re: Problem moving Access 97 app to newer versions (97 Sr-2)

    Are you by any chance running this on a Windows XP machine? Access 97 (in fact, Office 97) doesn't really play nicely with WinXP. We see problems on our XP machines at work linking to Access backends. Sometimes it just hangs the entire process for no reason we can see ... or it will work one time and fail the next. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> We haven't found a good reason or a good cure.
    Charlotte

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

    Re: Problem moving Access 97 app to newer versions (97 Sr-2)

    Hi Frank,
    A number of our loungers work with Oracle and Access 2000/2002 on a regular basis (I only worked with 2 and 97), so I suspect the problem lies somewhere in your configuration or with something unique to your particular database. You mention a form being bound to a datasheet - is that the same thing as being bound to a linked table? Also, how did you create your 2000 database - with the conversion process? The reason I ask is that we have seen problems with that from time to time - you might try creating a new blank database, and then import all of the objects from the 97 database, as that seems to work better. A third question - how much code is behind the form - if it's a legacy set of code (i.e. Access 2) there are a number of things that can cause problems? Finally, are you getting an actual crash message, or does Access just go away?
    Wendell

Posting Permissions

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