Need help with a new project

[faust7]

Hello!



I work for a small organization and we have 15 agents who take calls. We want to gather all their statistics in a database (date, time, reason of the call, extra comments, etc.) so I created a database with multiple tables (calls, agents, categories, reasons, etc.). The design of the table is finished and ready to be used.

Now, here's the problem. Each agent needs to have a stand alone form on their computer all open at the same time so they can all write in the table (only read, no modif, no reading). Originally, I wanted to use a web server and do it in php/asp with SQL but unfortunately, we don't have access to a Web server and I can't install anything on the network.

All I have access to is Microsoft Access 2003 and a SHARED DRIVE.

Any idea how I can have multiple users write (only) in a common Access database?

Your help would be very appreciated!

Thanks,

John

[RuralGuy]

http://www.accessmvp.com/TWickerath/.../multiuser.htm
http://www.access.qbuilt.com/html/ge...1.html#SplitDB

[faust7]

Thanks. I'll take a look at these links!

[RuralGuy]

Post back here is you want more assistance.