Networking a ms access template

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe Moon - 06 Oct 2004 20:40 GMT

Let me re-phrase my message. MS Access has a template
called " Asset Tracking ". It has the fields and the
reports that we want. We want to key in the items
(assets) on the template and share it with other users.
That ways we can access the same database, so that when
one user makes a change with a certain item, the other
users and our dept. sees the same changes. We are in the
process of purchasing a network server and we want to
utilize it. How can I share this template? Do the users
need to have a network version of ms access? What can
anybody recommend for us to do?

Reply to this Message

Larry Linson - 07 Oct 2004 00:28 GMT

Split your application into a front-end (queries, forms, reports, macros,
and modules) and give a copy to each user; link to tables in a back-end
(tables, relationships, and data) in a shared folder on the server.

There's an introductory presentation on Access in a Multiuser Environment
that I did for my user group that you can download from
http://appdevissues.tripod.com. It will identify topics that I thought
worthwhile to discuss, and a bit more. The best collection of detailed
information and links on the subject of Access in the multiuser environment
is at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP

> Let me re-phrase my message. MS Access has a template
> called " Asset Tracking ". It has the fields and the
[quoted text clipped - 7 lines]
> need to have a network version of ms access? What can
> anybody recommend for us to do?

Reply to this Message