Multi-User? JET? SQL Server?

[Knowledge]

I have been charged to solve a problem in an Access database someone else programmed, but before I do anything to the database, I need a little bit more information(I'm an Access newbie). Here's my situation :

My client has an Access database on the Server. There are three persons currently using this database. The problem is that to open the database they are all double-cliking on the same icon on the server. (which I think is WRONG...) Recently the database has been corrupted when two persons accessed to it at the same time.

Is Access multi-user? How can I set them up so they can all access to it at the same time? I was looking at the documentation about JET and SQL Server but I'm confused....

What I understand of it is I have to optimize the Access database to an Access Project so it can be shared to all three users. Do they need to buy SQL Server for that?

Please someone put me on the right track....I would really appreciate any kind of help!

Thanks!!

 

[Knowledge]

Thank you Pat! It helps me a lot!!

How would I split the database? Is there some kind of wizard that does that for me or I would have to do this manually? If that's the case, how would I do that?

And after the databases are split in two, I put the database containing the data on the server and every one gets a copy of the front end on their desktop, right?

Thank you SO much for your help!!

 

[Knowledge]

Okay, I found the way to do it. It works perfectly!

But what happens if 2 persons are trying to modify the same record at the same time?

 

[Knowledge]

Thanks! Your help is really appreciated.