VB6 Code run through macro in Office 2003

[qureshi]

Hi,
I had a vb6 program which was run through a macro in office 97. Recently we upgrade from office 97 to office 2003. When I run this program I get the Uninstallable ISAM error. I have tried to uninstall Access, uninstall whole of Office 2003. Nothing seems to work.
In the debug mode, i have seen that this error is generated when the program is trying to execute a query.

Any suggestions will be appreciated.
Thanks

 

[RaVeNCoder]

The ISAM it refers to is like a link between vb6 and a database of any sort, in this case it might be access. VB6 only works with access 97. If you save your database as an Access 97 file format it will work. You can also try to download new updates for vb6 but then you need to have vb6 installed on your machine. The quickest way to fix this prob is to save the database you are working with as a Access 97 file.

 

[johnwm]

VB6 will work happily with all versions of Access (and every other database with an ODBC interface available).

Make sure that your VB has an up-to date service pack (at least SP5) available from:

http://msdn.microsoft.com/vstudio/downloads/updates/sp/vs6/sp5/dnldoverview.aspx

or the currently just released SP6 available from:

http://www.microsoft.com/downloads/...b-2e89-4676-a16a-5c5477cb9713&DisplayLang=en)

If you're not running W2K or later as an operating system, get the latest MDAC and the JETSQL update.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[qureshi]

I am running windows XP. I have updated my system with the VB6 SP6 and also downloaded MDAC 2.8. No improvement at all.
Below is the first query in a series of queries this program run and at the first query the program stop with the "Couldnt find Installable ISAM" error.

I am still using the access 97 file.

sqlstr = "select Sum(Codesfrompastel.qtysold) AS TotalSold,codesfrompastel.shell" _
& " into test from codesfrompastel group by codesfrompastel.shell"

db.Execute sqlstr

Where can I go to check my version of JetSQL and where can I go to download the updated one if need be.

Thanks