Microsoft Access Help

[Mezz]

Hello,

I have created a database file on microsoft access and i want to be able to
have multiple users adding data to it at the same time how do i do this.

Thank you

 

[Wayne-I-M]

Hi

Check out this link

http://www.members.shaw.ca/AlbertKallal/Articles/split/

It will explain why and how to split your database

 

[Allen Browne]

Access is designed to be multi-user, so you don't need to do anything beyond
ensuring that users open it Shared.

However, it is a really good idea to split the database:
http://allenbrowne.com/ser-01.html

 

[Douglas J. Steele]

Split your application into a front-end (containing the queries, forms,
reports, macros and modules) and a back-end (containing the tables and
relations). Tony Toews has details about this at
http://www.granite.ab.ca/access/splitapp/index.htm

Only the back-end should be on the server: each user should have his/her own
copy of the front-end, ideally on his/her hard drive.

Make sure each user has a minimum of Read/Write access to the folder where
the back-end database is located. (It's usual to give them Delete access to
that folder as well)