Multiple Users

  • Thread starter Thread starter Elyse
  • Start date Start date
E

Elyse

Hi,

I am creating an application that uses SQL Server 2000 as the backend and
MS-Access as the front-end. Is MS-Access suitable for say.....15 or more
users?...or may you recommend a different front-end?

Thanks for your help
Elyse
 
With SQL Server as the engine, Access can be used for any number of
front-ends. They should be placed on the users local drive, however. You
also might want to consider creating an Access Project (ADP) instead of a
database (MDB) for this.
 
Hi,

I am creating an application that uses SQL Server 2000 as the backend and
MS-Access as the front-end. Is MS-Access suitable for say.....15 or more
users?...or may you recommend a different front-end?
Click to expand...

Access (with each user having Access installed and their own copy of a
frontend) makes a very good frontend to SQL; I don't think there would
be any real limitation on the number of users, 15 or 1500 should be
equally practical (given sufficient server capacity of course).
 
Back
Top