B
Bobby Jones
Does Access database system differ from Microsoft SQL Server 2000?
M
ManningFan
What Klaatu said. 
)
We use Access as a front end to a SQL Server backend, mainly because A)
Access is easy to work with and B) we typically have over 100M records
in a table and Access tables tend to blow up at 1M records.
If you're storing alot of data, I'd consider the setup we use. If
you're not going to go over 500,000 records in a table, just use Access
as both the front and back end.
)We use Access as a front end to a SQL Server backend, mainly because A)
Access is easy to work with and B) we typically have over 100M records
in a table and Access tables tend to blow up at 1M records.
If you're storing alot of data, I'd consider the setup we use. If
you're not going to go over 500,000 records in a table, just use Access
as both the front and back end.
B
Bobby Jones
thanks, that helps a lot 
Yes, by several hundred dollars
Actually, you are talking apples and oranges.
SQL Server is a database engine.
Access is an application builder.
You cannot build forms or reports in SQL Sever. It requires a package or
language capable of creating applications (VB, C++, C#, VB.Net, etc.) Those
mentioned do not easily produce reports. The most common reporting package
that can use SQL Server is Crystal Reports.
Access is a collection of tools that includes the Jet database engine. It
also includes a form builder, a report builder, and a query builder. (I
omitted Macros because they are seldom used by professionals). The
application you build in Access, by default, uses the Jet database engine;
however, you can use SQL Server, Oracle, MySQL, or other database engines
instead.