I am running a Access 2007 database which is filled by users which only have Access 2007 Runtime. The application was ini开发者_JAVA百科tially developed on WinXP and Acess 2007, now I am on Win7 and Access 2007.
Since I resaved the application, every client using XP encounters an error whenever the Ucase function is called.
For debugging purposes, I changed the Load-Sub of the main form to the single statement
bla = Ucase("foo")
Which brings the clients to the error message that there was a runtime error and the application has been halted.
I included error handling in the sub making it look like this:
On Error GoTo handle
bla = UCase("foo")
handle:
MsgBox Err.Number & ":" & Err.Description
Strange enough, the handle is being ignored by the runtime.
The problem DOESN'T show up on any client with either a full Access 2007 or Windows 7 installation.
I am a bit confused how the windows version has anything to do with it.
Any help to either solve the problem or Tipps to get to a specific error code would be greatly appreciated.
Regards,
tannerli
Generally speaking, when standard functions start throwing errors, it's because there's a broken reference to something. When any reference is broken, then all references fail, even for the standard libraries. Chances are, you have managed to reference to a newer version of one of the libraries that is not available on Windows XP.
精彩评论