Compiling problem after installing Office 2007 SP2

[PeterJC]

I have just installed Office 2007 SP2 and I now have problems in Access 2007.
1. My application will not now compile: I get the error message "Invalid
procedure call or Argument", and the line of code which is highlighted is
"Dim dbs as DAO.Database". This line was at the top of a code module as a
global line.
2. I tried to rename a form and got the message: "The OLE server may not be
registered. To register the OLE server reinstall it."
What is going on? Yesterday this application (before SP2) worked fine. Any
suggestions please?
Or should I uninstall SP2?

 

[Hans Up]

I have just installed Office 2007 SP2 and I now have problems in Access 2007.
1. My application will not now compile: I get the error message "Invalid
procedure call or Argument", and the line of code which is highlighted is
"Dim dbs as DAO.Database". This line was at the top of a code module as a
global line.

See Bob Larson's Quick Tutorial, "How to Check for Missing References":
http://www.btabdevelopment.com/main...eckformissingreferences/tabid/71/Default.aspx

 

[PeterJC]

Thanks for your res ponse, Chris. I tried what y ou suggested, and it still
won't compile, I got the same message, with the same words highlighted.
I tried putting the declaration in a code procedure, but got the same
message and nothing was highlighted.