I have recently been asked to amend the server IP address of an access .ade file as the Source Sql database was being moved. As the source code (.adp) file has been lost, I opened the .adp file and changed the connection. I know this worked as I then could see all the tables from the Sql DB.
the problem is that now when the user opens the database (which is supposed to run a form displaying a menu from what I can gather) , he gets the following error:
__________________________________________________________
The expression On Timer you entered as the event property setting produced the following error. The Operation on the object | failed.
* The expression may not result in the name of a macro, the name of a user-defined function, or [Event procedure]
*There may have been an error evaluation the function, event or macro
Show Help >>
__________________________________________________________
Obviously, being compiled code I can't debug and it doesn't seem that it can be decompiled (can Access be decompiled?). Truly stuck !
the problem is that now when the user opens the database (which is supposed to run a form displaying a menu from what I can gather) , he gets the following error:
__________________________________________________________
The expression On Timer you entered as the event property setting produced the following error. The Operation on the object | failed.
* The expression may not result in the name of a macro, the name of a user-defined function, or [Event procedure]
*There may have been an error evaluation the function, event or macro
Show Help >>
__________________________________________________________
Obviously, being compiled code I can't debug and it doesn't seem that it can be decompiled (can Access be decompiled?). Truly stuck !
