Access 2007 to SQL management studio 2008 issues; XP PRO

Im currently helping a company transition from access to SQL and im using XP pro, I made sure both programs full up to date, i renewed all the DLLs i could find in the forums, and then I imported the backend into SQL and kept the frontend in access.

My issue is, when I switched over, a few of my forms using the CreateObject line, give me a 429 runtime error. Everything runs fine when both the FE and BE are in access. I've tried everything I can think of and have not been able to get anywhere.

If you guys have any idea's please let me know!

Thanks a ton

Jordan