Database Server

How to setup an access database to a business server?

I'm an intermediate user in access. I've designed and created a database using ms access 2007. This databse was created for the staff within a small company. Everyone has the access to this database with a windows password. The majority can only view the data (from forms) and print reports, while only a few people can insert/delete/update the data within the database. My questions are:
- how do i connect my database1.accdb to the company server so that everyone can use it?
- what is the purpose of splitting the database? Should i split mine?
- where should i go from here?

Thank you.

You need to save the Access database on the server in a folder where everyone who needs to access it, can. This is done by setting permissions on the folder where the database is. You will need to allow update permissions for those people who need to update the database.

The best way to implement this is to split the database so that the client (PC) computers only have the minimum in forms, code modules etc. that they need.

Each user will need a copy of Access on their PC to use the server database. The tables (data source) on these PC's should be "Linked" tables (goto tables, right click on the table list and select "Linked Table". With client PCs using links to the real tables on the server, data is only held in one place.

Users who don't update the database don't need the forms that update so you will probably need an Update client database and a read-only client database. You distribute the correct version to the people that need them.

So.....each client PC runs your database but with links (Linked Tables) to the tables held in a central access database where the data is stored. The forms, reports and queries are stored in the client Access database. Only the data is stored centrally.

Hope that helps.