sharing database and getting notification when new entries are mad

[happyface]

I am new to Access but here's what I am trying to do. I want to put a
database on a network share that will be used by several people who will be
able to add in records. I would like to be notified via email when new
entries are made, how would I go about doing that?

 

[Maurice]

Why would you want that? When the db is used frequently you'll be bombarded
with emails. You might have to figure out first what it is you want to be
updated for. If you want it all you will create a lot of networktraffic just
by sending constant emails. Not to mention the fact that you have to catch
every insert action in the db to trigger a mailevent.

So give it another thought before proceeding with this idea...

 

[Jeff Boyce]

I'm with Maurice on this ... receiving an email every time someone added a
new record could get very old very fast.

An alternate approach, if you want to know WHO entered records and WHEN,
would be to add two fields to your table to capture the initials (user-name)
and date/time of the record creation.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Lance]

How often are new entries being made? Are you going to be getting a hundred
e-mails a day or one or two a week?

If it's only going to get a few records added per week/day the best solution
might be to create a form to overlay the table, when the user clicks on a
"finished" or "save" button it sends an e-mail.

Alternatively, if it's something that is going to see a lot of additions you
might want to store entry time/date and schedule it to send you a report once
a day.

 

[happyface]

I really appreciate the suggestion and will work on creating a form.