I am just learning Access 2003. I am required, for work, to create a
database that will aloow several users to enter information. I created a
database with a form with several pages or tabs for each workgroup and
thought the best way to allow multiple users to enter the information was to
create subforms and post them on a web page. Do the subforms need to be on
the main form? I am really overwhelmed.
WHOA!!!!
Access? Webpages? Is this an Access .mdb file (which does not play nice with
web browsers) or an Access Data Project? Do you even know what a subform is??
Step back a bit. Access databases are multiuser out of the box. This has
NOTHING WHATSOEVER to do with tabs or pages. It's possible to have a single
database on a shared server and have multiple people open it simultaneously;
each will have access to all the forms, tables etc. in the database.
However, this approach is risky: performance will suffer, there'll be a risk
of contention for objects, and corruption is a possible problem.
Instead, you should use a "split" database architecture: one "backend" .mdb
file containing the Tables, and each user getting their own copy of a
"frontend" .mdb or .mde file containing the forms, queries, reports, etc.
linked to the tables. See
http://www.granite.ab.ca/access/splitapp.htm
for details on how to set this up.
Also see the tutorials here, especially Crystal's introduction:
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials