I am trying to make my app flexible and accept code on the fly.
I am using msaccess 2003 for the frontend and MS SQL2000 for the backend. I compile all projects and the users run an *.ade file.
currently I create the dynamic code in T-SQL and execute it on the SQL server. This as it is not secure and could crash with the wrong code. I want to execute the code locally and/or use VBA code.
So basically I would like to create a string like:
str2Exec = "=iif(Value = 1, "S", "C")"
Then Replace the "Value" with a real number:
str2Exec = Replace(str2Exec, "Value", 1 )
Then finally exec the string and save the result
strResult = RunVBA(str2Exec)
Any ideas on how to execute this code on the fly?