Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    May 2002
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error Opening Access Data Base (Access 97)

    I have about 60 people that use a database to search to past job data. The database resides on our server and the only thing that sits on the workstations is the Access 97 software and the shortcut to the database. My problem is that everybody but one person can open and use the database just fine. That one person was able to use it fine until I loaded the windows script host 5.6 on his computer for other purposes. Not it says the following error:

    "The expression On Open you entered as the event property setting produced the following error: ActiveX component can't create object"

    The strange thing is, I loaded the Windows Script Host onto quite a few computers but this was the only one that crashed afterwards. On this computer I have noticed that his DAO was version 3.5. Most of the others were version 3.51. Still some say the use 3.6 but it is missing and it still works perfectly. Does anyone have an idea? This has both myself and the programmer that created it stumped.

    I have already tried reinstalling Access.

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

    Re: Error Opening Access Data Base (Access 97)

    Do all the machines have the same service pack for Access 97 and the same Jet sp installed? I belive that DAO 3.51 was installed with the first service pack for either Office 97 or Jet 3.5. DAO 3.6 is the version that goes with Access 2000 and 2002.
    Charlotte

  3. #3
    New Lounger
    Join Date
    May 2002
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Opening Access Data Base (Access 97)

    Hi Charlotte,
    When I go to "About" it says that they are all Access 97 SP2 so yes on the Access service pack, but I'm not sure about the Jet sp. Would I be incorrect in saying that the Jet SP would be installed with the Access SP? DAO 3.51 is not an option one this particular machine when I go to register the ActiveX controls, just 3.5.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error Opening Access Data Base (Access 97)

    You can download the latest update to Jet 3.5 from ACC97: Updated Version of Microsoft Jet 3.5 Available for Download

  5. #5
    New Lounger
    Join Date
    May 2002
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Opening Access Data Base (Access 97)

    Thanks, I'll try this and let you know. BTW, I just ran SR-2b service pack and it didn't fix it either.

  6. #6
    New Lounger
    Join Date
    May 2002
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Opening Access Data Base (Access 97)

    You know, when I run these updates and restart nothing seems to be updating. I ran both the SR-2b SP and the Jet SP and neither gave me the option to register DAO 3.51. It still lists DAO 3.5 only. I ran them on a test computer too and it did update to 3.51. I'm really confused now? What would keep this from upgrading like this?

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

    Re: Error Opening Access Data Base (Access 97)

    Did you ever get this problem resolved? (If you reply to your own message, some of us may not realize it's unresolved, as some depend on the email copy of the message to follow active threads.)
    Wendell

  8. #8
    New Lounger
    Join Date
    May 2002
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Opening Access Data Base (Access 97)

    Actually, not yet. I've stopped working on it for now, but next I'm going to move all the DAO related DLL files to a temp directory and reinstall Office to see what happens. This particular person doesn't use our in-house DB's that often, so its low on the priority list for now.

Posting Permissions

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