HELP! Data access problem VB6 - .txt & .xls

[eblattner]

Hello, I have a MAJOR problem. I have an app that imports data from a text database, puts it in an Access database, sorts and matches, and writes to an Excel file. When I try to access the text database, or the Excel database, I get an error 3170 (Couldn't find an installable ISAM) I have encluded the ISAM files (mstext40.dll, msexcl40.dll, odexl32.dll, and odtext32.dll) but still get the same error. I am not using any code to connect to the databases other than binding them to a data control. I am using the P&D Wizard that comes with VB6 SP4, and have updated with Mdac_typ and vb6cli but the error still comes up. The error does not come up on a machine with VB6 installed, but I don't know which files I am not including. Please help, I have writen these apps for a corp, and they need tham as soon as possible. Thank you for ANY help.

THANK YOU! -Eddie

 

[listener22]

Taking "Thank you for ANY help." literally,
some options are:

sell or lease your computer to the corp;
faster and cheaper ones are coming out all the time
install vb6 on all machines using your app, i.e. have the
corp buy as many copies as needed
depending on the size of the text database,
get a copy of it regularly and do the processing
at your home or office until you can figure out the problem

Well none of those are really any good, but the point is,
don't remain stuck. If you are really stuck, then almost any
action is a step in the right direction.


Jim

oracle, vb, some javascript

 

[eblattner]

Thank you for the advise. I figured out what the problem was thursday. The P&D Wizard that comes with VB6 is bad. I used the one that came with VB5. It asked on anbout the 3rd or 4th screen "Does the program require any installable ISAM's" It seems VB6 does not care about these. When I made the setup with VB5 app wizard, everything worked great (I did have to add DAO350.dll). Thanks for the help though!