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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
