Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

VB6 & Access 200 DB - works great on most Win2k boxes, but not on 2 ----- HELP!!

Avatar of cas27
cas27 asked on
Visual Basic Classic
14 Comments1 Solution325 ViewsLast Modified:
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.  
Avatar of David Lee
This problem has been solved!
Unlock 1 Answer and 14 Comments.
See Answers