Does MS Access db have problems with multiple users access it at once?

Does MS Access db have problems with multiple users access it at once?

Post by chloemelmo » Thu, 27 Nov 2003 04:50:11


I am developing an Access db which will be used by multiple users. My
questions are:

Does MS Access have problems with multiple users accessing the db at
once?

If yes, what is your solution to this problem?

I was informed that Access is not a good application for multiple
users accessing it at once.

Thank you for your assistance to this issue of mine.
 
 
 

Does MS Access db have problems with multiple users access it at once?

Post by alweine » Thu, 27 Nov 2003 08:41:53

Will the users just be reading, or will multiple users be writing at
the same time? I've seen data corruption in older (Access '97)
databases with large numbers of users reading and writing. I haven't
seen any corruption where there's only one user writing.

You might want to take a look at using MS-SQL, but it depends a lot on
and whether the complexity of the application warrents the add'l
resource investment...