Can Access XP co-exist with Access 2000 ?

[Yetie]

My client has Office version 2000, I have Office XP.

I'm confronted with the following problem: the Object Library I can reference from VB is MSACC.OLB (version 10, or XP), but what I would need is MSACC9.OLB (version 9, or Access 2000). Is it possible to have both Access versions at the same time on my system, without the one getting in the way of the other, so that I can create a program that accesses the database at my clients?

Any advice would be most welcome.
Yetie.

 

[ChrisCalvert]

Not sure if this might be on the right track, but here is something I used for a simillar problem. I had to use several versions of Microsoft Money on the same system and what I did was have each one installed to it's own directory. Then I had a little VB program I wrote to run registry entries that changed which one was 'installed'.
You could use a batch file even. Launch with the batch file which runs the reg entries, then launches the .exe
(You could use a registry tracker , Norton for instance, to see which keys you'd need to have in the registry file).
Hope this helps.

 

[oharab]

This is for Access 97 & 2k.
It might work for Xp as well though:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q241141

B ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------

 

[Yetie]

Tnx both to you, Chris and Ben!

I managed to circumvent my problem using "late binding" in my VB-code calling Access. The inspiration for this solution I found, thanks to your suggestions, in the following article:

http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q246237

I did quit working with a direct reference via the GUID, and called Access via the ProgID (Name-referencing) instead.

Yetie.

 

[tgikristi]

I don't know if any of the original posters are around, but I have a similar problem in that I went and created a database (my first database) in Access XP for a client with only Access 2000--I thought I was OK by using the default Access 2000 file format, but I only have the Object Library 10.0 reference and the client only has the 9.0 reference. The client will be using 2000 for the forseeable future.

Is there some way I can download the 9.0 reference and switch to using that in my database before?

Thanks!
tgikristi