Results 1 to 11 of 11
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problem with Engine.35

    I have a form where I am using vb to store the data to a database. Out of 30 people here, 27 of them are working fine. The ones that I am having problems with are the ones using OS2000 and Office 2000, eveyone else is using Office 98.

    When ever they start to open the form they abort out of it and show this line: "Set OBe - Application.CreateObject("DAO.DBEngine.35")". Again this only happens to the Office 2000 users.

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Engine.35

    I forget the file name for DAO, but you can see it in your VBA IDE, References list. Check the version number. I suspect your Off2k users simply have a different version than your Off97 users. Install the older (Off97) version on your Off2k PCs.

    p.s. There was no Office 98.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,853
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Problem with Engine.35

    This sort of error can be very complex to solve - just having a file is only part of the solution. I sometimes get errors where Jet is not registered successfully (especially after Project has been removed from the machine). I would also recommend you look at the following article where Microsoft have addressed a similar issue
    Andrew Lockton, Chrysalis Design, Melbourne Australia

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

    Re: Problem with Engine.35

    Access 97 uses DAO 3.5 and the dll is DAO350.dll. Access 2000 uses DAO 3.6 and the dll is DAO360.dll. However, you didn't say what version of VB you are using. VB 5 goes with DAO 3.5 and VB 6 expects DAO 3.6. Just installing DAO 3.5 on the O2K machines won't make it work because that's only one of the libraries that comprise DAO. The fact is, your line Set OBe - Application.CreateObject("DAO.DBEngine.35") is trying to call Access 97 on an Access 2000 machine, which will only work if you install the Access 97 database engine on those machines. I know that Access 2000 can work with 97 backends, but I don't have a virgin Office 2000 machine to see if the earlier DAO is also installed. Even if it was for compatibility, though, the DBEngine object is always going to be Access 2000 on those machines.

    BTW, there was an Office 98--for the Mac!
    Charlotte

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Engine.35

    When I type Office 98, I was thinking of Outlook 98. Sorry, about that.

    I am doing the whole thing out of Access 97 & Outlook 98, using VBA script in of Outlook. Wish I could use VB, but that is not in this years budget.

    Is it possible that I could add a line and somehow have it check the OS? Then from there have it look for the right engine. BTW, if this is possible, is it hard? I am not a programmer and I'm being "forced" to learn as I go.

  6. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Engine.35

    Char,

    Thanks for filling in the details. I should have been clearer. I know just copying a dll doesn't cut it.

    I have a similar situation here with the ADO library on Win2k an Win98 PCs. The Win98 PCs get ADO 2.1 when IE 5+ is installed. Win2k PCs get ADO 2.5 installed with the OS. These are my observations, anyway.

    Our consultants informed me all PCs would be upgraded from Win98 to Win2k before the go-live date for my big Office app. I took them at their word, and "upgraded" my Office app to use ADO 2.5. Unfortunately, Win98 PCs remained and none of them could run the app -- Compile error in hidden module (ADO reference invalid). The ADO 2.5 referenced in the app was not installed on the Win98 PCs. The fix was to reference ADO 2.1 and not the new ADO 2.5. Apparently, ADO 2.5 provides the msado21.tbl for backward compatibility.

    Maybe, Mr. Reyes could benefit from something along this line.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  7. #7
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Engine.35

    Ah, yes, the Mac. Wasn't that a beaver skin hat worn primarily by bankers in England sometime in the last century? I didn't know they still were making those in '98.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  8. #8
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Problem with Engine.35

    (Off-topic but...) "Mac" was short for "Mackintosh", which was a raincoat, named for the lightweight waterproof fabric it was made of (I guess they could have had Mac hats too).

    If your association of Macs with bankers in England by any chance comes from the Beatles song "Penny Lane", it is interesting to note that that came out on the Apple label!

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

    Re: Problem with Engine.35

    You'd be better advised to upgrade the ADO on those machines, since 2.5 fixes some problems with 2.1. The MDAC_TYP.exe file for MDAC 2.5 is still available for download from Microsoft and 2.5 will work with Access 97 as well.
    Charlotte

  10. #10
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Engine.35

    Good advice. Thank you!
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  11. #11
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Engine.35

    Penny Lane, yes, and A.A. Milne. But now that you have clarified, it was indeed a rain coat Christopher Robin was wearing (but he also had the rain hat, too)-- See "When We Were Very Young". Therein lies the confusion that has existed in my brain for at least 3 years. Remember, I'm only 8 and I don't believe in Santa Claus. So, it was my improper assumption that the reference "Mac" was to the hat, not the coat. Since English bankers all wear hats (another assumption, see "Mary Poppins"), I took the "banker never wears his Mac in the pouring rain" to refer to the hat, which HE was not wearing -- dumb banker.

    Alas, he's dumber than I thought. No raincoat!

    Looked what I learned today, Mom!
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

Posting Permissions

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