RunTime Error:429

[gtree]

Hi,

I have created an application with Access and the Backend and Frontend using Access VBA. I am connecting the frontend and the backend using the link tables feature in Access. It was running fine on my earlier machine which had ME and office 97. My new machine has Win XP profession and the same office 97.

When I try to run my program it gives the following error
"RunTime Error:429. Active X component can't create object"

I tried loading MDAC.EXE
I tried loading the MS Soap Toolkit 2.0 and 3.0
I tried loading ssubtmr6.dll

Neither of this worked on my machine.

The program runs fine on another machine with XP professional.

Can someone please guide me what I could be missing here?

Thank you.

 

[Junior1544]

track down what line of code is causing the error, then you'll have an idea what's going on...

The way i do this, is i figure out what button push or event it's being caused in, then put a line break in the first line of code and step it till i know what line is causing the problem.

That'll tell you what reference isn't right...

hope this helps...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[gtree]

Hi James,

I tracked it down.

I have a Database Object declared and Im setting that Database object to current databse

The error occurs at this line

Set db1 = CurrentDb

Any clue what I could change to get it working?

 

[Junior1544]

sounds like you don't have DAO referenced... try going into a module and declaring it...

also, make sure it's not missing, that's another possability...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[gtree]

hi James,

You said I should try going into the module and declare. can you tell me how I can declare it?
and what did you mean my its not missing?

Thanks