size Limit of Access Database?

  • Thread starter Thread starter TC
  • Start date Start date
Hi, I am going to design a Database for a warehouse which
need to support intranet (Actually, a local network
between 8-10 PC ). I am desiging to use SQL or Access as
the database. Using Access, the advantage is loser cost
but compare with SQL is less powerful and less relibile.
Do anyone know the database size and preformance
limitation of Access? and the advantage , disadvantage for
both? Thansk
 
Access 2000/2002 size limit is 2GB per mdb file. 8-10 users is not a
problem, assuming you build the application according to best practices for
a multi-user app.

SQL Server does have an advantage in online backups, server-side processing,
integrated NT security, etc. But you pay extra for it.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Back
Top