SQL searches slower than Access?

DBSilver wrote: In My experience, when you search for 1 record out of 10 total - Access will normally outperform SQL Server.  As your database grows in size you will see a crossover point where SQL Server will total outperform Access.

DBSilver has a point there.  Access is designed for relatively smaller databases and is designed for a limited amount of users accessing at the same time.  It has less overhead in doing searches because it isn't expecting 1000 people accessing at once. 

SQL, on the other hand, is designed for larger databases with a lot a users accessing the data at the same time.  This requires more overhead.  For smaller databases with not many similtaneous users, this would actually slow down your search.  Once you get to a certain size and/or a certain amount of users accessing similtaneously, SQL will outperform Access every time.

Also, when the Access database gets too big and/or too many users try to access it at the same time, you will start to have problems and slow access with Access.

If your website is smaller with a small community and you don't plan on going big time, then Access may be the way to go.  If your site is big, or you plan on making it big, then SQL is the way to go.