Can multiple users use Access at once?

T

TSynapse

My company is considering using Access for one of our applications. My
questions are:
1. Can mulitple users access the database at once?
2. Can mulitple users make changes to the application at once?

Thank you.
 
R

Rick B

Yes, if you split the database and store the backend (data) on a LAN and the
frontends (forms, reports, and queries) on each individual PC. Obviously,
changes to the front-end would need to be made on a master copy, then
distributed to each user.

You can't make any changes to the backend table structure while users are
using them. You'd have to get everyone out.
 
A

Aaron G

TSynapse,

1 - Yes. Make sure you set up your database correctly to handle multiple
users properly. You basically have to split the database. Don't worry, it's
easy and automated.

2 - Yes (and no, if you like). I'm assuming you're talking about multiple
users changing the data. That's fine. If you're talking about multiple
users making changes to the back end table design at the same time, then no.
You can also assign user permissions.

Since I'm not sure of any details of your organization, I can't tell you if
it would be perfect for you. I would do a google on the limitations of
microsoft access to see what it CAN'T do too.

Hope this helps.

Aaron G
Philadelphia, PA
 
A

aaron.kempf

dude screw MDB in the mouth

use Access Data Projects; that way you get a LOT better performance.
i'm just tired of running mdb across a lan; it is too slow

you would basically version the ADP file and move it to the client; i
woudl reccomend doing that.

and then you can copy objects in and out of other access proejcts and
mdbs using docmd.copyobject i thought or something along those lines
 
Top