Detect new record in multi user database ?
Posted on 2004-04-05
I have a MS Access application where 15 users are connected to a shared mdb database on a "server". Everytime a user adds a new record to the database (only 1 table) from a client computer, the info that was added to the table must be printed out as a report.
I do not want to share the printer on the "server computer" and use the shared printer on all 15 computers, I just want to send data from the client to the server computer and print it. Nice, clean and simple. Though I say simple I have no idea how to detect that a new record was added to the table ? I do not want to scan the table with a filter or a query by using a timer in form in order to detect new table entries...
There must be an elegant way to code this ?
An idea anyone ?