We are looking at using Access for
our animal registration program. We
are wondering if different users
would be able to access and put in
information from other computers
if our database is put online.
What do you mean "online". It is relatively easy to create an Access
multiuser database if all the users are on the same LAN. It is possible to
use a Jet database (the one that is Access' default) with different user
interfaces (not Access) if the database is on a website. Actually there is
an option called Data Access Pages, but its limitations are so severe that
it normally is useful only on an intranet (which likely implies on a LAN,
and multiuser would be better in that case).
Yes, either is possible. On a LAN is easier. On a website is more work, but
you can still use the Jet database, likely with an .asp (Active Server
Pages) application or the more recent ASP.NET application.
How is security handled in this case?
Access security is normally used on the LAN-based multiuser scheme.
User-coded security is the order of the day when creating an ASP or
ASP.NET -- you can substitute third-party packages for writing it yourself.
Larry Linson
Microsoft Access MVP
