How can I allow multiple users to edit a shared database?

[CarlaInJax]

We have an Access database that needs to be edited by several users.
Currently, only one person can access at a time to input information. Can
several users access the database and input information simultaneously? I
have an Excel spreadsheet that will do this, but cannot find out how to do it
in Access.

 

[Ofer Cohen]

Check this link about "Splitting a Microsoft Access Database", essential to
make the database a accesable by more then one user

http://www.databasedev.co.uk/split_a_database.html

 

[dbahooker]

a) throw away MDB
b) use Access Data Projects
c) keep your data in a format with a future.
MDB has been obsolete for 10 years now.

 

[dbahooker]

more people use SQL Server than MDB.

any day of the week.

a lot of people also waste a lot of time doing crap like compact and
repair.

does it mean that it's the right choice?

SQL Server is 100 times easier to deal with than MDB.

Sprocs and VIews are just flat-out more powerful in SQL Server than in
your silly trivial MDB apps