Which database is fast sql server or Ms Access for my C#.net window application ??

i want to know that which database is fast for accessing data for my window application ??
SQL server or Ms Access

give me some suggetions ...

Who is Participating?
lee555J5Connect With a Mentor Commented:
Access is great for single users or small groups on a LAN where you can store the .mdb or .accdb file on a network share. A step up in performance is SQLite or MS SQL Server Compact Edition, both of which are single files on a network share - easy to administer. The next step up is MS SQL Server Express, but now you need a Windows Server to host it. Finally, as Neilsr has suggested, if you are running a networked, production application with more than 5-10 users, you need to go all the way to MS SQL Server, Oracle, MySQL, etc.

Neil RussellTechnical Development LeadCommented:
If your talking about a networked, production application then put access away and forget about it. USE MSSQL
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

SQL Server, even .NET studio provides SQL Server database file for attach by default
I agree with Neilsr. Only reason to use Access would be if you were running something small on one computer and didn't want to mess with installing SQL Server.

Give Neilsr the points, but figured I'd add some additional info to the answer.
Neil RussellTechnical Development LeadCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.