many thanks to this forum for helping me build my business information management tool. Although it is not finished i (an above all the clients) are please with it.

Now could use some advice on using the access.log file.

I want to trace everything that is done by users with the database (because of accountance certificate).

Switching on the logging would do the trick because every submit is stored in access.log ( i have not tested this but i suppose it)

However, i have the feeling that this log file will increase rappidly.

when i run my app on a OS X server, i their i change that i will run into file limitations.

Should i internediatly backup the log file and start all over again.

So basicly my question is : what is the "best:" way to log user access.

Thanks for any advice on this one.

Jitse

I was using FM database and Inline on each HTML/CDML page to get precise log of user movements.

Hi, Jitse! I am not a log-hound but maybe you could write something to automate this for you (as long as FMP does not consider it an OPEN FILE all the time). I would probably do it from the Mac OS X command line using a unix app called CRON (cron, crontab, etc.) but you could probably also do it in AppleScript or something. Or like you said, you could just reset it when you back up your systems. For someone else who didn't need EVERYTHING, I might recommend an INLINE ACTION to create a record in some type of log.fp5 database.

Again, I know little of logs, though. Maybe some of the pro's will tell you what they've done. --ST

LOL! I write too many words and Anatoli submits his before I finish. Yeah, INLINE... good idea! LOL!

Thanks for all the advice,

Standard logging by filemake logs all the movements (including switch layout, switch pages etc).

So, i need to add an additional submit form to all the pages that cheges records, adds record etc.

No problem and thanks.

Jitse

BTW, in Lasso is free MySQL -- LassoMySQL, excellent for such Inline task with FM based data source