I have a 40 MB Access 2002 front end. I use the decompile, compact,
recompile and compact procedure prior to releasing new versions to keep
the
application size to a minimum.
Lateley I've been getting run time errors after using this process. There
are no compile errors as the project will successfully compile.
I traced one of the problems and found that a string litteral passed byval
to a function was resulting in an empty string within the function. As an
example:
Function SomeFunction(ByVal vstrParam As String) As Long
SomeFunction = Len(vstrParam)
End Sub
?SomeFunction("A String")
results in Zero!
My workaround today was to release the application decompiled and it seems
to be running without any problems.
Has anyone else run into wacky issues with decompile/recompile?
Has anyone run into wacky issues after installing WinXP SP3?
Patrick
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Patrick Jackman
Vancouver, BC
