MS Access 2000 Networking Project

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Riptide - 17 Mar 2005 21:26 GMT

Hello,

I have just started my first access project and need some help.
The setup would be 10-12 people working on a LAN accessing the database.

My question is how to implement a Microsoft Access 2000 database across
this LAN for multi-user access:

[1]in the best possible way

[2]what options do I have and

[3] requirements for server and client PCs

If possible can you give some scenarios.

Any help would be greatly appreciated.
Riptide.

Reply to this Message

Tony Toews - 18 Mar 2005 23:52 GMT

>I have just started my first access project and need some help.
>The setup would be 10-12 people working on a LAN accessing the database.
[quoted text clipped - 3 lines]
>
>[1]in the best possible way

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.

>[2]what options do I have and

This is a bit too generic.

>[3] requirements for server and client PCs

Whatever you already have.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Reply to this Message