SQL Server or Access?

[Matthew]

Can somebody give me the main differences between SQL Server and Access?

Matthew

 

[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

 

[Joe Fallon]

SQL Server also costs a heck of a lot more! <g>

 

[Van T. Dinh]

.... and another software like Access / VB / ... to develop the Front-End,
i.e. GUI.

 

[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)

 

[Guest]

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.

 

[Matthew]

Thanks to all for the replys.

Is a SQL Server database edited in Access?

Matthew

 

[Van T. Dinh]

If you mean adding / editing / deleting data, yes.

HTH
Van T. Dinh
MVP (Access)

 

[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.