gaz01

Hi can any one help me please.

I have moved a legacy program from NT to a 2000 platform and all i am recieving is Run Time Error 3633 cannot load MSJTER35.dll

I Have installed the Jet Update and the MSJTER35.dll Service Pack and this has been no help

I have also followed the ms knowledge base article (Q174488) which refers to modifing the DAO Object Library within my project and this did not rectify the problem either.

Does anyone out there now a way around this cos im stumped

Thanks in Advance

QuantumCat

this may seem silly -but it's worth a shot:

Have you tried (because I assume it's either a reference or a component) to un-check the current reference (or component) and check/add the one you installed?

It seems similar to what I got when switching from Win2000/Office 2000 to
winXP/OfficeXP (and I had to make the references again as well as the changing the components)

furthermore: have you installed all windows updates and service pack 5 for VB? (check the references & components for versiondifferences)

If that's not it -you'll have to wait for someone with a specific solutions, cause other with than these general tips I can't help you

G'luck

QC

QuantumCat

have you installed SP4 for windows 2000?
or do you need that for .NET hmmm

it's worth a try?

g'luck

QC

gaz01

Fixed It

It was noting to do with the dll but some offending code

The offending code was

Set TheDB = DBEngine.Workspaces(0).OpenDatabase("", False, False, "driver={SQL Server};server=x;database=x;uid=x;pwd=x;dsn=x;")

I was missing the database call. (database=x

Dont know why it worked on one server then not the next

Bizzarre

Cheers for the help..

QuantumCat

These things happen -dunno why- must be a version difference?

I had office codes working in VB -I used the macro recorder -so it was VBA, to be presice. BUT it worked. Then Office XP updated itself and all my office codes failed.
(I had to write out all the references to the objects. e.g.
"with .worksheet" had to become: "with object.excel.worksheet(1)")

So these things happen. But -it's heck debugging them

glad you got it ;-)