centralizing the database

Hi,

I have a small access application ..Now i want that application to be used by 2 people..with a single database..

I have a server also..should i keep the database in the server..

Please help me out..

Thank you,
HimaBindu

You are best using the built in tool "Database Splitter" found in Tools>Database Utilities this will split your database into 2 parts Frontend (FE) that will contain all your forms, modules, queries etc and Backend (BE) which will contain all your tables/data.

Locate the backend on your server and put copies of the Frontend on the networked PC's. The server will have to have the correct shares enabled in its folder to prevent "locking" and if simple file sharing best to map as a network drive.

Try splitting your database first and having a play.

Good luck John

PS. If you move the Backend file you will need to use the "Linked Table Manager" in your front end to update the table links location.

thank you..very much..i will try..

Thank you very much..

I will try..