OLEDBCommand Busy Fetching,Open

I have a C# windows application that opens up an MDB file and allows to search for a term and then delete all of the rows after it.  On my development box, I can run the code in the debugger and also install the application and run it.  But if I try to install and run the application on a users PC I get the "OLEDBCommand busy fetching,open" error message.
I have been working with 3 machines:
1 - Development box - Win2k prof running Visual Studio 2002 with .Net Framework 1.1 SP1. MS Acccess  2002 installed.
2 - Win 2k Prof with .Net Framework 1.1 SP1.  MS Access Not installed.
3 - Win 2k Prof with .Net Framework 1.1SP1 MS Access 2002 installed.

At first I didn't have Framework 1.1 sp1 installed on the devleopment dox, so I installed it and updated at the .net references and re-compiled it.  But this did not work.

I don't know where to look in the code of the problem since it works fine on my dev box.  I have researched the error and found that it usually means the oledbcommand is being called twice simutaneously, but why would it work on the development box.

Any ideas on what the problem could be?

Thanks,
PatriotsFan
patriotsfanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

_kiwi_Commented:
Did you check the MDAC versions on your development boxes ?

Since you use a MDB file, I guess Access has to be installed on all of your deployment boxes (I see one of them doesn't have it).

Visual Studio 2002 works for .Net Framework 1.0, not 1.1, so having the .Net Framework 1.0 SP2 installed instead of the .Net Framework 1.1 may be also an idea.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
patriotsfanAuthor Commented:
I needed to install .Net 1.0 SP3 on the workstations but did not need MS Access to be installed.

Thanks!!
Patriotsfan
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.