access a database with multiple users

[habbabub]

how can i change a database to allow multiple access?

is there a downside to doing this?

eg. if two or more people are trying edit the same feild???

 

[KenHigg]

a. Put the tables in one database file and put it on a shared server, put everything else like the forms and queries and reports in a second database file and put a copy of it on each users workstation. Link this database to the tables in the dataabse on the server.

b. Using MS access in this manner is one of it's core strengths.

c. You can set it up where it will warn you that two users are accessing the same record, etc. You do have several options in this area...