Question MS Access for multi user

[jackryan]

hello,

im making a simple msaccess database and i want it to be used by about 5 users simultaneously. im using access 2007 but the file format is in 2003. any help please?

thanks


edit...
i'm not using vb for front-end

 

[boblarson]

You need to split the database -Frontend/Backend and give each user a copy of the frontend on their machine. Then you should be good, even with the file format in 2003.

 

[jackryan]

sir,

thank you for your reply, i tried your suggestion, but im curious when 2 user simultaneously use the same form, only one person can edit the data. is it because of record locking?

 

[twoplustwo]

Hi Jack,

You need to split the db, probably make an MDE out of the front-end master and give EACH user a version of the MDE (do this via sending by email, external hd, usb stick whatever).

Your post above is the reason why we want to split the db.

 

[apr pillai]

Open the Form in Design View. Display the Form's Property Sheet and check the Record Lock Property setting. There are three options available: 1. No Locks, 2. All Records, 3. Edited Record.
Check whether All Records option is set or not.

 

[apr pillai]

Editing problem

Open the Form in Design View. Display the Form's Property Sheet and check the Record Lock Property setting is not All Records.

 

[jackryan]

thank you for your explanation, i set my Record Lock Property into Edited Records and it seems that this is really what i want.

 

[jackryan]

when multiple user use the splitted mdb, it becomes a little slow, is that ok?