I am using the DAO method for my project, and intend to build a multi-user program. Is it true that using DAO, only one person can access the Access Database at a time?
Printable View
I am using the DAO method for my project, and intend to build a multi-user program. Is it true that using DAO, only one person can access the Access Database at a time?
Nope. :)
i guest MS Access can support 10-20 connection at the same time. please correct me if i'm wrong.
If performance is not an issue Access can hold 255 concurent users.
Somone say it degrades after 20 or so i'd push that up to 60-70+.
Depending on the setup.
b :)
oh..ya... that good, as i only try out max of 10 connection concurrent :p don't have that much of client in the app i have dev
I have worked on an Access database with >50 users using DAO. Performance was merely OK, but we had serious corruption problems. Mostly is was with records with memo datatypes, and I suspect if you avoid data types which store a pointer to where the data is stored (OLE datatypes are similar) this problem may not occur.
I would err on the side of caution and plump for SQL server if more than 10 users were required, but for just 10, you should be fine.
thanx for the opinoins, well...hm.......in truth, i'm onli developing a minor application to support less than 10 users for sure
so if i place the database at the server, how should i connect the client PCs to the database located on the server?