Access XP to Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
__________________________________________
 
Hi Tom
The debugging message is as follows
Run - time error 91
object variable or with block variable not set.
 
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
__________________________________________
 
Back
Top