Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access XP to Access 2000

Discussion in 'Information Technology' started by Ali, Jul 28, 2006.

Tags:
  1. Ali

    Ali
    Expand Collapse
    Guest

    I have access xp professional on my laptop and I need to open files on a disc
    that have been saved with access 2000 when I try to open the files I get a
    debugging message come up. Can I install office 2000 along side Office XP on
    the laptop without it affecting my documents that I have produced in Office XP
     
  2. Loading...


  3. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hello Ali,

    Is there a particular debugging message that is displayed, or does a module
    just open and display code when you open the database? If it is the latter,
    a simply solution might be to simply click on Debug > Compile {ProjectName}
    from the VBA editor menu. If this option is grayed out (unavailable), then
    make any slight change in the code, such as hitting the space bar. Then the
    option to compile should become available.

    You can install office 2000 along side Office XP, and in general they work
    okay together (I have Access 97, 2000, 2002 and 2003 installed on the same
    partition of my PC). You may run into minor glitches here and there, but
    nothing that cannot be solved. However, if the only reason that you are
    contemplating this is due to a code window being opened unexpectedly, you may
    be able to remove the ghost breakpoint by simply recompiling the code.


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Ali" wrote:

    > I have access xp professional on my laptop and I need to open files on a disc
    > that have been saved with access 2000 when I try to open the files I get a
    > debugging message come up. Can I install office 2000 along side Office XP on
    > the laptop without it affecting my documents that I have produced in Office XP
     
  4. Ali

    Ali
    Expand Collapse
    Guest

    Hi Tom
    The debugging message is as follows
    Run - time error 91
    object variable or with block variable not set.

    "Tom Wickerath" wrote:

    > Hello Ali,
    >
    > Is there a particular debugging message that is displayed, or does a module
    > just open and display code when you open the database? If it is the latter,
    > a simply solution might be to simply click on Debug > Compile {ProjectName}
    > from the VBA editor menu. If this option is grayed out (unavailable), then
    > make any slight change in the code, such as hitting the space bar. Then the
    > option to compile should become available.
    >
    > You can install office 2000 along side Office XP, and in general they work
    > okay together (I have Access 97, 2000, 2002 and 2003 installed on the same
    > partition of my PC). You may run into minor glitches here and there, but
    > nothing that cannot be solved. However, if the only reason that you are
    > contemplating this is due to a code window being opened unexpectedly, you may
    > be able to remove the ghost breakpoint by simply recompiling the code.
    >
    >
    > Tom Wickerath
    > Microsoft Access MVP
    >
    > http://www.access.qbuilt.com/html/expert_contributors.html
    > http://www.access.qbuilt.com/html/search.html
    > __________________________________________
    >
    > "Ali" wrote:
    >
    > > I have access xp professional on my laptop and I need to open files on a disc
    > > that have been saved with access 2000 when I try to open the files I get a
    > > debugging message come up. Can I install office 2000 along side Office XP on
    > > the laptop without it affecting my documents that I have produced in Office XP
     
  5. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Ali,

    Is it safe to assume that you are not getting this error when you run the
    code in Access 2000? If so, the first thing I would look for is any
    references that are marked as MISSING. Here are some articles on this topic
    that are helpful:

    Solving Problems with Library References (Allen Browne)
    http://allenbrowne.com/ser-38.html

    Access Reference Problems (Doug Steele)
    http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

    Fixing Missing References (Jeff Conrad)
    http://home.bendbroadband.com/conradsystems/accessjunkie/references.html


    You may need to re-register your copy of DAO360.dll. Click on Start > Run,
    and enter the command:

    Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

    (Verify first that the path shown above is valid on your PC).

    If you still have trouble, post the full procedure for the affected code.
    Indicate which line of code is bombing out.


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Ali" wrote:

    > Hi Tom
    > The debugging message is as follows
    > Run - time error 91
    > object variable or with block variable not set.
     

Share This Page