The data I am using is from a personal geodatabases (.mdb). I am using the event layers (not the tables) as the inputs for the tool. The Route field type is text for all of the event layers i've tried this with. I've tried both but I usually have the POINT event layer as the 'Input Event Table'.
I've tried outputting to a few different locations... When I try to save to a personal geodatabase (.mdb) i get a more specific error: 'ERROR 999999: Error Executing Function. The table was not found. [test] Failed to execute (OverlayRouteEvents)'
When I try to save to a file geodatabase (.gdb) i get a similar error: 'ERROR 999999: Error executing function. The table was not found. The table was not found [test] The Microsoft Jet database engine cannot find the input table or query 'test'. Make sure it exists and that its name is spelled correctly. Failed to execute (OverlayRouteEvents)'
When I try to save to a plain old directory, in this case 'C:\Test' I get a less helpful error message: 'ERROR 999999: Error executing function. Failed to execute (OverlayRouteEvents).'
PS I just tried copying my source tables and the route reference to a file geodatabase (.gdb) and displaying the route events all over again. I made sure the workspace was set to the same file geodatabase and saved the output to the same location and I still get the same error.