using database and forms on intranet

[vjpkr]

Hi, below is my requirement.

1. Build an empty db in access
2. share a form with all the fields of the db with users over intranet.
3. whenever a user fills the form, saves and submits it, it should get updated in the database. Also send a mail to a certain mail-id.

The database will be on my desktop. all the users desktops are connected using a office network(intranet).




any help regarding this is really appreciated.

Thanks a lot,
VJPKR.

[June7]

Review
http://office.microsoft.com/en-us/ac...010342026.aspx
http://databases.about.com/od/tutori...itaccessdb.htm

A database with multiple users can work without splitting but it is usually best to split.