how do i add my access 2003 database to a network

[Tech Support]

i have a access database that runs all the office and all the contacts i need
it so when one member of staff makes an update it automatically updates on
all the pc's and it needs to be stable and trust worthy since this database
will be running the whole business

 

[Daniel Pineault]

First off, you need to split your database. Then you will place the
back-end on the central server and distribute the front-end to the users.
This step is critical! Do not allow multiple users to work from the same
front-end... you will eventually end up with corruption.

You also need to convert your db front-end from an mdb to an mde to avoid
users meddling with forms, reports, coding... and believe me they will!
Avoid the issue altogether by utilizing Access' built-in functionalities.

As for stable and trust worthy, a lot has to do with your network. Access
is very sensitive to network issues. So if your network is unreliable then
so will Access. On the other hand, if your network is stable so should be
Access.

You also have to think about backups! Plan for disaster now will avoid any
issues down the line. Setup a simple scheduled task on your server to
perform a copy of your database 1 a day, 1 a week depending on your needs and
you will thank me later.

So Recap:
*Split
*Covert to mde
*Distribute
*Setup Backup