ordendelfai
Technical User
My company is trying to determine what platform to build a fairly complex application for about 60 users. At any one time, all 60 might be logged in.
I have a lot of experience building an Access 97 front end linked to SQL Server 2k tables, but only for small user groups (10 max who almost never work in the same tables). These small user applications have worked great.
It seems like it would be a bad idea though to build an Access 97 front end to a SQL server with 60 users due to that the Jet Engine is still in effect with a SQL server back end (right?). Even if each user has a local install of the Access front end, I am very concerned how Access and SQL would concurrent data entry into the same table (or even worse the same record!). I confess that I really do not know the technical reasons why. I need to justify using a more traditional development platform by explaining why this setup is poor.
If you have some feedback why it would be a bad idea, especially if you know of an article or document that explains why, I would appreciate it.
Or maybe I am wrong and it wouldn't hurt to have that many users with this setup, let me know if that is true please!
Thanks =)
~Joel
~Joel
As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.
I have a lot of experience building an Access 97 front end linked to SQL Server 2k tables, but only for small user groups (10 max who almost never work in the same tables). These small user applications have worked great.
It seems like it would be a bad idea though to build an Access 97 front end to a SQL server with 60 users due to that the Jet Engine is still in effect with a SQL server back end (right?). Even if each user has a local install of the Access front end, I am very concerned how Access and SQL would concurrent data entry into the same table (or even worse the same record!). I confess that I really do not know the technical reasons why. I need to justify using a more traditional development platform by explaining why this setup is poor.
If you have some feedback why it would be a bad idea, especially if you know of an article or document that explains why, I would appreciate it.
Or maybe I am wrong and it wouldn't hurt to have that many users with this setup, let me know if that is true please!
Thanks =)
~Joel
~Joel
As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.
