Is there a way to have FMP create a log file of any changes that have been made to a db? We had some strange things happen to one of our dbs and we haven't worked on it for awhile. I was wondering if someone else got in and made any changes. A log file would be able to tell me when the change was made. I don't know if this is possible but I will take any input you can give.

Thanks,

John

Do you mean changes in data or structure?

The system I've developed here is extremely script driven, and I ccan see how I might generate an activity log, but I would be concerned with the overhead that this would impose as every script (i.e. every button) would make a new entry - I could easily be looking at 1000's per day from a user base of 30.

Enough said of that - but scripting is probably the only way.

I have also had several "strange" events, but a bit of sleuth has always proved responsibility with the users.

I was only thinking about logging changes in structure.

Analyzer from Waves in Motion can do this. I haven't used it personally, so I can speak for it's exact usefulness, but it sounds like what you are after.

http://wmotion.com/analyzer.html

<snip>

...and create difference reports to track changes over time...

</snip>