VB6 & Access 200 DB - works great on most Win2k boxes, but not on 2 ----- HELP!!
Posted on 2004-03-26
This is a second post from the VB DB topic area - but due to lack of response I am posting it here as well.
Ok, i have this VB6 app that talks to an Access 2000 DB. The users login to the app, then a basic set of data is pulled from the DB based on their login. On my PC, I can login, and see the basic data. On the problem PCs (there are 2 of them) I can login, but the basic data is not pulled from the DB. Now, I know they are talking to the DB correctly since it logs them in and asks them a question based on their login. Also, the DB is not corrupt as I have taken the working DB on my PC and trandfered it to their PCs and still no joy.
Here is a desc. of my machine and the problem PCs:
WORKING - Win2k SP4 - MDAC 2.8 from 2.6, Access 2000 (v 9.0.2720) -- this is my PC
- Win XP SP1 - MDAC 2.7 SP1, Access 2002 (v. ??) --- another users PC
NOT WORKING (others) - (1) Win2k SP4 (French Version) - MDAC 2.8 from 2.6, Access 2000 (v. 9.0.2812)
- (1) Win2k SP4 (French Version) - MDAC 2.8 from 2.5, Access 2000 (v9.xxx SR-1) - I don't remember the exact version number except that it was SR-1
I should mention that these are traveling users so I do not have access to the PCs. I will be getting them Friday evening - gotta love working late on Fridays... ;-)
Am I leaving any info out that you need? Any help would be appreciated! TIA for the help!
**Note: It was suggested that I deploy my app via the Package and Installation wizard - but I am already doing it that way.