I'd like to compare the database here in the office to the database that I allow web users to modify and script it so that I can see what files have been deleted by web users, any ideas?

Web users shouldn't be able to delete FM files. If you mean "records" instead, relate the two files by a sequential, auto entered record ID. In the related (web) file create a field called Constant (calculation, number) = 1. View this related field from the non-Web file and do a find for Relationship::Constant = 0 (or Relationship::Constant = 1 and omit). This will diplay the records in the non-web file which don't have corresponding records in the web file.

-bd