Is it possible to create an output file upon record insert?

[mcglone]

Ok, here's the situtation. I have a front-end application which takes user input from a browser window and, through ODBC inserts records into an Access Database. However, the back end application needs a text file (comma delimitied CSV), not an Access Database.

I've been tinkering around in Access a bit and found that I can utilize the AfterInsert event to trigger the writing of a file. However, it seems to me that I can only attach this to a Form, not a Table. Therefore, if I insert a new record using a form within Access, it works just fine but, if I insert the records from my front-end application (via ODBC), the code is not executed.

Is there a way to execute that script without ever launching Access? I'd really like this file creation to happen silently - simply put, every time I insert a record to my database from my front end app, I'd like Access to take that record and create a text file based upon it.

Does anyone know if there is a way to do that?

Thanks,
Corey

 

[Pat Hartman]

What you need is a trigger. Jet does not support triggers. You would need to switch to Oracle or SQL server or something else that supports triggers.

 

[mcglone]

Thanks, Pat.