I'm picking apart some very complicated database coding written about 5 years ago by someone who's left the company. When I say very complicated, what it does isn't complicated, the way it does it is.....for example, there are HUNDREDS of functions within the coding, some that do ridiculous things like put 15 lines of error trapping around a 1 line command and others that complete multiple different functions based on the variable passed to it by the calling process. This is made all the more complicated in that I'm not an Access developer, I'm an Excel VBA developer and am having to Google quite a lot of the commands I'm not familiar with.....once I've identified it's not a self created function the author is calling
One such function uses the 'DoCmd.DeleteObject' to.....delete stuff. The code looks like this:
Please Login or Register to view this content.
And I've just stumbled across one of the (many) calling processes, however, the sub it's being called from is supposed to be for compacting and backing up the database. The calling code is:
Need a little help here cos the MS-help page isn't being. I was under the impression that DoCmd.DeleteObject acTable.......is used for deleting tables. However, the calling code suggests it's being used now for deleting a compacted database file.Please Login or Register to view this content.
Wtf?
Bookmarks