Hi there. Ive posted this elsewhere but was wondering whether anyone else had some input on this.
I have designed an access database using Access 2000 and VBA 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? I am not able to get onto all the machines of users to copy the libraries on to their machines as I dont know who the users will be. Can I create some sort of exe file to extract the libraries onto the user's machine, without messing up their installation of Access? How would I do this?
Many thanks for your help.
Bretto
I have designed an access database using Access 2000 and VBA 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? I am not able to get onto all the machines of users to copy the libraries on to their machines as I dont know who the users will be. Can I create some sort of exe file to extract the libraries onto the user's machine, without messing up their installation of Access? How would I do this?
Many thanks for your help.
Bretto
