If you have a long and tricky sub routine, create a string variable to hold the status of what you are up to and make sure you update it as you go. This makes it a lot easier to debug RTEs, as you can then put the status in the error message.
And a quick tip for recovering corrupted databases - If the compact/repair function doesn't fix things, create a new database and import all of the objects.
You can also export a text definition of all objects using the undocumented SaveAsText function (try typing it in the debug window - it will prompt you with the parameters, but no help available). Recreate the object by using the LoadFromText function.
And a quick tip for recovering corrupted databases - If the compact/repair function doesn't fix things, create a new database and import all of the objects.
You can also export a text definition of all objects using the undocumented SaveAsText function (try typing it in the debug window - it will prompt you with the parameters, but no help available). Recreate the object by using the LoadFromText function.