Access 2000/2002 Compatability

[Bretto99]

Hi there. Some advice for a rookie?

I have designed an access database using Access 2000 and in a Windows 98 environment. It is to be used (single user at a time) on computers running Windows 98 and 2000 and above, and Access 2000 and Access 2002.

I have two compatability problems:

1. The database opens fine when I run it on a machine running Windows XP or windows ME with Access 2000, but then when I try to open this same database on a machine with Windows 98 it is not happy, and as far as I can see 'corrupts' the installation of Access 2000 on that machine.

2. The database will not run in Access 2002. I have isolated this problem down to the fact that if I go to Tools>References in the visual basic editor of the Access 2002 machine it says that (I think) Microsoft Windows Common Controls 5.0 (SP2) or something like that is missing. I then uncheck it and choose another Common Controls and it works just fine on the Access 2002 machine. So I guess it has something to do with the libraries being "lost" across versions. I think something similar is happening when I move down in windows versions...

Can anyone advise me how I make sure that the libraries are "transported" with my database to make the database openable on all machines, up and down versions, whilst at the same time not messing up the installation of Access on any users machine?

Many thanks for your help.
Bretto

 

[Darrylles]

Hi,

I think that you need to install all relevant libraries on each client machine (it's the client's Access version that runs the server application, if you're using a server).

It's the same if you developed the db on a machine with later version libraries - it used later libraries, therefore each client can't interpret the code because it's libraries are out of date.

The op. sys difference won't matter, running Access 2000 with Access 2002 won't matter - running Access 2002 with Access 2000 WILL matter (won't work - try opening a Word 2000 .doc from Word '97).

Regards,

Darrylle



"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[Bretto99]

Thanks for your input Darrylle

A couple of questions

1. How do I install the libraries - where do I copy them from my own PC? Can I save them on a disk?

2. Will I corrupt the various clients machines by installing my libraries on them? Especially if the libraries are earlier versions than what they have.

3. Do you know if there is any way of creating an .exe to install these libraries. This db is to be distributed to a number of users on a CD Rom, so I have no control over installing them myself.

Re your op sys comment: I have actually had hassles with the operating system, using the db from a Windows ME machine on a Windows 98 machine - even though both are running Access 2000!

Thanks
Bretto