I am looking for some info about the benefits of Access vs SQL Server.  

(Please tell me there are some!).  If anyone has any ideas, please email 

me at; bulent.yazici@n... .. I have developed a site using .asp 

running on an Access server and now I have to write a report about it and 

justify using Access. 



Cheers



Bulent

Not Much.... the only thing i can think of is its in-expensive.



Daniel



-----Original Message-----

From: Bulent Yazici [mailto:bulent.yazici@n...]

Sent: Wednesday, March 21, 2001 1:15 AM

To: ASP Databases

Subject: [asp_databases] Access vs SQL Server





I am looking for some info about the benefits of Access vs SQL Server.

(Please tell me there are some!).  If anyone has any ideas, please email

me at; bulent.yazici@n... .. I have developed a site using .asp

running on an Access server and now I have to write a report about it and

justify using Access.



Cheers



Bulent

Access is much much cheaper and very suitable for small sites with limited

concurrent visitors.



-----Original Message-----

From: Daniel O'Dorisio [mailto:dodorisio@h...]

Sent: Wednesday, March 21, 2001 7:58 AM

To: ASP Databases

Subject: [asp_databases] RE: Access vs SQL Server





Not Much.... the only thing i can think of is its in-expensive.



Daniel



-----Original Message-----

From: Bulent Yazici [mailto:bulent.yazici@n...]

Sent: Wednesday, March 21, 2001 1:15 AM

To: ASP Databases

Subject: [asp_databases] Access vs SQL Server





I am looking for some info about the benefits of Access vs SQL Server.

(Please tell me there are some!).  If anyone has any ideas, please email

me at; bulent.yazici@n... .. I have developed a site using .asp

running on an Access server and now I have to write a report about it and

justify using Access.



Cheers



Bulent



---

SoftArtisans helps developers build robust, scalable Web applications!

Excel Web reports, charts: http://www.softartisans.com/excelwriter.html

File uploads: http://www.softartisans.com/saf.html

Transactional file management: http://www.softartisans.com/saf1.html

Scalability: http://www.softartisans.com/saxsession.html

ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html



swatermasysk@c...


$subst('Email.Unsub')

Merhablar!



The only good thing about it, if you don't have SQL it

is the best thing. You could you a database. If you

have SQL Server than it is much much better. Faster to

get result for your query, better managment for the

memory, more secure and better functinalities.



I hope this would help!



Bye!



Atilla Yadik

Hi All,



Thanks for the messages.. I have done some more research and could only 

come up with the following if anyones interested;



MS Access is easier to use and it is readily available in all of the USSU 

computers, therefore it will allow future webmasters the ability to change 

the database manually if needed.  According to Mike Chapple , MS Access 

provides users with one of the simplest and most flexible DBMS solutions 

on the market.  Regular users of Microsoft products (which is many) will 

enjoy the familiar Windows ?look and feel? as well the tight integration 

with other Microsoft Office family products.  



MS Access is also thought to be faster if the database size is not big.  

SQL Server shows it?s full potential when there are thousands of entries. 

(This last statement is something I can't source yet as it's something I 

was told a long time ago but can't seem to validate it anywhere)



Other than the above two statement, i really can't seem to be able to find 

anything else.



But, the cost issue is great as I can include that in my dissertation!



Cheers



Bulent Yazici

University of Surrey Students Union Webmaster

http://www.ussu.co.uk

webmaster@u...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

: MS Access is easier to use and it is readily available in all of the USSU

: computers, therefore it will allow future webmasters the ability to change

: the database manually if needed.  According to Mike Chapple , MS Access

: provides users with one of the simplest and most flexible DBMS solutions

: on the market.  Regular users of Microsoft products (which is many) will

: enjoy the familiar Windows ?look and feel? as well the tight integration

: with other Microsoft Office family products.

:

: MS Access is also thought to be faster if the database size is not big.

: SQL Server shows it?s full potential when there are thousands of entries.

: (This last statement is something I can't source yet as it's something I

: was told a long time ago but can't seem to validate it anywhere)

:

: Other than the above two statement, i really can't seem to be able to find

: anything else.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Transaction support? Replication? Accessing remote servers? Disaster

recovery? Built-in security? Better DDL support? Stored procedures?



Cheers

Ken