CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 12 of 12
  1. April 15th, 2003, 12:38 PM #1
    bobhaynes_1
    bobhaynes_1 is offline Member
    Join Date
    Apr 2003
    Location
    Pennsylvania
    Posts
    52

    Problems when moving from win 2000 to win 98

    Hello, I'm relatively new at this so I'm hoping there is an easy solution! I developed a database application using vb 6 and access 2002 on a windows 2000 machine. My vb program just displays data that is in the access database and allows the user to add new records, delete records and update records. On my development machine it works fine. I have an adodc control and the data is displayed in a data grid.
    :
    : When I move my exe and mdb and access and vb runtime files to a win 98 machine, it does not work correctly. I'm getting the error "Runtime-error 91, Object Variable or with block variable not set". I believe the error is occuring on "Adodc1.Recordset.Requery". The form never even gets a chance to load the data into the datagrid. If anyone would please be able to give me some pointers I would really appreciate it! Thanks again,
    :
    : Bob
    Reply With Quote Reply With Quote
  2. April 15th, 2003, 12:59 PM #2
    M Owen
    M Owen is offline Senior Member
    Join Date
    Jun 2001
    Location
    Mi
    Posts
    1,249
    Did you install the correct MDAC on this win98 machine?
    Reply With Quote Reply With Quote
  3. April 15th, 2003, 01:01 PM #3
    phinds
    phinds is offline Senior Member
    Join Date
    Aug 2001
    Posts
    1,447
    I don't know for sure that it is relevant to your specific problem, but there are definite known problems with backwards compatibility (basicially it is very flaky) between Access 2000 and Access 98. If your problem is one of those problems, there is no solution that I know of. You have Microsoft to thank for that.
    phinds
    vs2008, 3.5SP1 Version 9.0.21022.8 RTM
    Reply With Quote Reply With Quote
  4. April 15th, 2003, 01:02 PM #4
    bobhaynes_1
    bobhaynes_1 is offline Member
    Join Date
    Apr 2003
    Location
    Pennsylvania
    Posts
    52
    I've installed version 2.7. Does it matter if that is the same version of mdac that's on the development machine?
    Reply With Quote Reply With Quote
  6. April 15th, 2003, 01:05 PM #5
    bobhaynes_1
    bobhaynes_1 is offline Member
    Join Date
    Apr 2003
    Location
    Pennsylvania
    Posts
    52
    My database is an access 2002 database. I've distributed the access run time files with it as well so my understanding is that the 98 machine should not even need to have access installed.
    Reply With Quote Reply With Quote
  7. April 15th, 2003, 01:06 PM #6
    M Owen
    M Owen is offline Senior Member
    Join Date
    Jun 2001
    Location
    Mi
    Posts
    1,249
    You have to have the MDAC for the version of Access AND the components used in Access ...

    Phinds has a point ... Access 2002 may not be compatible with win98 ... A test of it would be to try to install it and run Access from there ...
    Reply With Quote Reply With Quote
  8. April 15th, 2003, 01:07 PM #7
    M Owen
    M Owen is offline Senior Member
    Join Date
    Jun 2001
    Location
    Mi
    Posts
    1,249
    Bob,

    Distributing the runtime files doesn't do jack ... It's the MDAC ...

    And no, I don't do rap ...
    Reply With Quote Reply With Quote
  9. April 15th, 2003, 09:06 PM #8
    Thread1's Avatar
    Thread1
    Thread1 is offline Elite Member
    Join Date
    Jan 2003
    Location
    7,107 Islands
    Posts
    2,487

    Lightbulb

    The Jet library is not included on MDAC version 2.6 and above.. Just a reminder...
    Busy
    Reply With Quote Reply With Quote
  11. April 16th, 2003, 03:57 AM #9
    Nick A.
    Nick A. is offline Member
    Join Date
    Dec 1999
    Posts
    128
    A little risky (there is a small change you may damage your Win98 installation) but try to create a setup in Win2K for your application (so all the necessary libraries will be included in it), then install it in the Win98 machine and then try to run your app from within VB. Hopefully it will work.
    -------------------------
    Nick A.
    Reply With Quote Reply With Quote
  12. April 16th, 2003, 07:54 AM #10
    bobhaynes_1
    bobhaynes_1 is offline Member
    Join Date
    Apr 2003
    Location
    Pennsylvania
    Posts
    52
    Thanks everyone for all of your help! I got it to run on 98 by building a package with the P&D wizard and then installing it that way! I guess just moving the vb exe and runtime files is not the best way to do an install!

    One more question though...If my vb application only uses ms access as a backend database, does the client machine need to have access installed? Do I need to load the access runtime files or is mdac sufficient? Thanks again for all of the help!

    Bob
    Reply With Quote Reply With Quote
  13. April 16th, 2003, 08:00 AM #11
    M Owen
    M Owen is offline Senior Member
    Join Date
    Jun 2001
    Location
    Mi
    Posts
    1,249
    Bob,

    Again ... It's the MDAC. That is all that is needed to access an Access DB ... You do not need to install Access or Office XX to work with an Access DB. If you want the interactive frontend of Access then you'll have to install it ...
    Reply With Quote Reply With Quote
  14. April 16th, 2003, 08:03 AM #12
    bobhaynes_1
    bobhaynes_1 is offline Member
    Join Date
    Apr 2003
    Location
    Pennsylvania
    Posts
    52
    Sounds good. Thanks for all the help!

    Bob
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured