Access 2007 run time problem

[IainIDI]

Still works in full access, still blows up in runtime

Thanks for all the help guys, really hoping we can get to the bottom of this

 

[IainIDI]

Also, I've been trying to probe the underlying reasons that this is happening. For whatever reason, there is a subtle difference between the full version of Access and the runtime with the handling of the recordset.open command.

Does anyone know of any differences between full Access and runtime? Has anyone heard of errors like this before?

If not, is there another way for me to get the information I need? I realize I'm probably not including enough specific information to get detailed answers but I'll be here all day checking this post to provide more information.

I appreciate the help, I really do

 

[RuralGuy]

Have you applied the Office 2007 update yet?

 

[boblarson]

And make sure you apply the Runtime Update as well.

 

[IainIDI]

wow - so surprising how sometimes the most simple fix works

SOLUTION: Update Full office install and runtime install

Many thanks for your help, problem solved!

 

[boblarson]

Glad to hear you finally got it worked out.

 

[phantom29]

What is the code behind strSql?