M
Matthew
Can somebody give me the main differences between SQL Server and Access?
Matthew
Matthew
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
SQL Server process queries on the server rather than on the client. The SQL
statement is sent to the server where it is processed and only matching
records and fields are returned across the network to the client. Access
process the query on the client. Depending on indexes and lots of other
factors, much more network traffic is generated.
Other points regarding SQL Server:
-has more robust security
-can authentic users based on their network login
-supports triggers
-can be much larger
-can handle many more users
-can be programmed with stored procedures and user defined functions
-software costs more (relative) but can be a much better investment
-has DTS which is awesome
-much much more
-doesn't have forms and only recently has a decent reporting tool been made
available http://www.microsoft.com/sql/reporting/default.asp
statement is sent to the server where it is processed and only matching
records and fields are returned across the network to the client. Access
process the query on the client. Depending on indexes and lots of other
factors, much more network traffic is generated.
Other points regarding SQL Server:
-has more robust security
-can authentic users based on their network login
-supports triggers
-can be much larger
-can handle many more users
-can be programmed with stored procedures and user defined functions
-software costs more (relative) but can be a much better investment
-has DTS which is awesome
-much much more
-doesn't have forms and only recently has a decent reporting tool been made
available http://www.microsoft.com/sql/reporting/default.asp
J
Joe Fallon
SQL Server also costs a heck of a lot more! <g>
V
Van T. Dinh
.... and another software like Access / VB / ... to develop the Front-End,
i.e. GUI.
i.e. GUI.
D
david epsom dot com dot au
Another opinion:
SQL Server requires a part time DBA and the support of the
IT department. Access does not.
If your application is of such importance to the organisation
that it requires a part time DBA and the support of the IT
department, then using SQL Server has very little downside.
Whereas Access/Jet/File Server may not offer the characteristics
you need in that situation.
(david)
SQL Server requires a part time DBA and the support of the
IT department. Access does not.
If your application is of such importance to the organisation
that it requires a part time DBA and the support of the IT
department, then using SQL Server has very little downside.
Whereas Access/Jet/File Server may not offer the characteristics
you need in that situation.
(david)
I
itareus
You could always start with Access and if required "upsize" the data and structure to SQL server at a later date
You can link SQL server data to access by using "File" "Get External Data" "Link Tables" and selecting files of type ODBC data sources
Full details are in the Access help documentation.
You can link SQL server data to access by using "File" "Get External Data" "Link Tables" and selecting files of type ODBC data sources
Full details are in the Access help documentation.
M
Matthew
Thanks to all for the replys.
Is a SQL Server database edited in Access?
Matthew
Is a SQL Server database edited in Access?
Matthew
V
Van T. Dinh
If you mean adding / editing / deleting data, yes.
HTH
Van T. Dinh
MVP (Access)
HTH
Van T. Dinh
MVP (Access)
J
John Vinson
Thanks to all for the replys.
Is a SQL Server database edited in Access?
It can be - that is to say, you can use Microsoft Access as a tool to
edit data in SQL databases.