Class Id error

[Tekvet]

I admit to being a rookie VB programmer but I've run across a problem that is confusing the heck out of me.

I made a survey app that asks users questions then stores them in a single table in an Access database (datcontrol.recordset.addnew, .update) On my own computer it works perfectly [img]/w3timages/icons/grin.gif[/img] (Win98, VB 6.0, Access 2000) When I tried it on 3 other computers, they came up with 2 different sets of errors. [img]/w3timages/icons/sad.gif[/img]

Computer 1: Win95, Access 2000. Manually loaded and registered vbrun50/60.dll just in case the installer wizard didn't setup correctly. When I start the app, it gives a Class Not Registered error and looks for a CLSID number that I can't find in the MSKB. (I'm not really even completely sure what a class id is let alone how to look for it or define it.) When I click OK, I then get a runtime error 91 because it couldn't load the datcontrol. Any ideas on what to try next?

Computer 2/3: WinME/Win98, Access installed on both. On these computers I'm getting "database in unrecognized format" errors. Access will read/edit the databases on both computers but the VB program won't recognize them. Is this because I'm using the "old" dat control instead of the "new" ADO control? Any other ideas?

Thanks for reading a long post and TIA for any help you can give me.

[Kevin]

Most likely you are using a control that emmanates from a dll or ocx that is either absent, not registered or not licensed on the target PCs.

Just a precautionary note: are all versions of Access the same? If not, it might be a good idea to upgrade to the same version you are developing on.

I have found ADO far easier to code and far more reliable than any other db access technology. I think if you do not have IE 5 or 5+ you have to explicitly install ADO to your PCs. It gets installed with IE.

Hope that helps, but I hope someone who knows better will chime in.

[Tekvet]

Thanks for the reply Kevin.

Is there a good way to find out what dll/ocx's a control is "linked" to - other than compiling and seeing what errors pop up?

The odd thing is that all computers are running the same version of Access. The computer with class id error is running Win95, IE 5.0 installed. The computer that's not recognizing the database is WinME, IE 5.5.

If you happen to think of anything else, I appreciate the tip. Meanwhile, I'll be smacking computers with a big stick. [img]/w3timages/icons/wink.gif[/img]

Thanks!

[steve-eyer]

Hi Kevin,
Ihave the same Error 91, coupled with a Error 3633. My copy of Auction Assistant Pro from BlackthorneSW (for auction management & uploading to eBay, etc.)won't load after a bout with a virus. I thought I had all the dll's back into the computer, but when I try to load AAPro, it stops on Error 3633 (MSJTER35.dll won't load){it is in there, in windows/system. Then when I ok that box, I get the Error 91. object Variable or With block variable not set.
AAPro then stops and goes to "not responding"

What shall I do next? I have reloaded Win98 a couple times and IE5.5 a couple times.

Best,

Steve

[charlotte]

Have you reinstalled the program? The library is one of the Jet libraries for Access 97. If the program uses a runtime version of Access, renaming the existing file and reinstalling the program should put the dll back.

[charlotte]

The "old" data control is DAO-based, while Access 2000 defaults to ADO, but if you're only using Access as a back-end, that shouldn't matter. As long as the appropriate references are set in your VB project, Access shouldn't care. It sounds like your datacontrol didn't register properly on the target machine. You might want to go back and check all the dependencies, rebuild the setup, and try it again.

Can you find the CLSID in the registry? I'd suspect that part is a browser version issue, so check the CLSID key under the browser.

[Tekvet]

Is there a way to determine what the CLSID should be/is for a program? When I compiled a VB program (references an Access db), I didn't see anything that refered to a CLSID. I searched the registry after I installed it on another computer and didn't see a reference to CLSID there either.

Assuming there's a way to find what the CLSID is/should be -- can that be manually entered into the registry?