If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Difference Between access and SQL Server
Does Access database system differ from Microsoft SQL Server 2000?
|
#2
|
|||
|
|||
Difference Between access and SQL Server
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. "Bobby Jones" wrote: Does Access database system differ from Microsoft SQL Server 2000? |
#3
|
|||
|
|||
Difference Between access and SQL Server
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. Bobby Jones wrote: Does Access database system differ from Microsoft SQL Server 2000? |
#4
|
|||
|
|||
Difference Between access and SQL Server
thanks, that helps a lot
Klatuu wrote: 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. "Bobby Jones" wrote: Does Access database system differ from Microsoft SQL Server 2000? |
Thread Tools | |
Display Modes | |
|
|