Best Practices When Using Microsoft Office Access 2003 in a Multi-user Environment

This Microsoft article runs through a raft of things you should think about when deploying Access in a multi-user environment. It's not comprehensive, so review my other posts on multi-user deployment as well.

How do I create an MDE, ADE, or ACCDE file?

Here's another great "soup to nuts" post from Walter at UtterAccess.com. This one covers everything you need to know about creating end user versions of your database for deployment.

deployment, multi-user, security, splitting, network

Sharing an Access Database

Here's a great post from UtterAccess.com on splitting your database into Back-End and Front-End and deploying it for multiple users.

Quote:
"Congratulations! Your database has become so popular that others would like to use it. Just copy it to a shared location on the network and create shortcuts, right? Wrong! This is perhaps the largest cause of Access database corruption. Multiple users accessing the same .MDB at the same time is just asking for problems.
... this FAQ is meant to provide the best practices for sharing a database with others. Incorporated into these best practices are the concepts of Maximum Security, Future Manageability, and Higher Degrees of Scalability. Simply put, your database will be as secure as possible, as easy to modify as possible, and as easy to migrate to a larger platform when and if you ever outgrow Access."

deployment, multi-user, splitting

Deploying an Access Application over a Local Area Network (LAN)

This page runs through a variety of topics related to deployment in a LAN environment, including (among others)performance suggestions and splitting your database.

It includes links to a variety of tips and references, as well as some specific techniques.

Note that the suggestions to use a batch file to deploy front-ends may not be "best practice", there are other alternatives to accomplish the same goal. You should review these and determine which fits your situation best.

deployment, multi-user, performance,network

Microsoft Access Performance FAQ- Tony's Microsoft Access Page

This page is a collection of performance related topics from Tony Toews, a Microsoft Access MVP.