HELP! Run-Time error '3170': Couldn't find installable ISAM.

Hello,

The program I'm working on right now is a VB program that accesses a Microsoft Access database. This program must be distributed among all the computers in labe within the campuses of the college I'm attending. This application is finished but does not work. There is one error when accessing the Access DB that comes up.

Run-Time error '3170': Couldn't find installable ISAM.

This program has to run on computers that are independent of having visual basic and microsoft access installed on them. From what I looked up on the internet I have discovered that it has to do with Microsoft access. But I need a solution thats friendly to the school's computers as these computers are old and I cant download and install VB's SP5 on each computer as visual basic is not to be installed on the computer in these labs, same with MS Access. There is a program one these computers that does use an Access file and has no problem. This program is very similar to the one I made. But it works and mine doesn't.

Has anybody had this error before in a visual basic program that accessed a MS Access DB?

Does anybody know how to fix this without installing anything? most of the solutions I've seen involve me installing patches that I cant install on all the computers here.

Thank you for your help and sorry about the long post.
anelaAsked:
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.

magnus23Commented:
Hi anela!
Can you provide more information please?
Such as your Connection string, Access version.
If it is text files then problem can be in your connection string. I've had the same problem before several times. There are various possible causes.

Here are some articles

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q155/6/66.asp&NoWebContent=1
http://support.microsoft.com/?kbid=209805
0
spongieCommented:
I think you're having an installation error particularly drivers needed for your app to access the msaccess db.  Did you include MDAC_TYP.EXE in your package? You may also run this separately.  You can also find the latest version here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=9ad000f2-cae7-493d-b0f3-ae36c570ade8&DisplayLang=en
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

mquirozCommented:
hi Anela!

can you post your connectionstring? also it would be usefull if you tell us what ADO version you're using...
0
anelaAuthor Commented:
Thank you so much guys, and sorry about the lack of responses.  Things got very crazy here at work and I didn't have an opportunity to respond as quickly as I would have liked.

Thanks again. :)
0
bra_brankoCommented:
I made a aplication in Visual C++ ( 6 ) and use  SQL 2000.
Without anyi reason   ( not always) I get brake with message
" This program has ... ilegal operation " . Can you tell me what problem is ???

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
Visual Basic Classic

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.