Access or SQL

[redundguy]

The word SQL primary means a standard for working with relational databases. This standard language contains statements like SELECT, UPDATE, DELETE, INSERT and so on. All the major databases use this standard: Oracle, MicrosoftSQL, Informix, DB2, Sybase,.. Access is not a major database. It is not 100% SQL compatible. But you can use SQL syntax for almost all statements because Access recognizes this standard syntax. For example, to link 2 tables in a SELECT statement you use JOIN word in Access, but SQL standard use WHERE clause to link 2 tables; but you can use also the second choice because Access understands it.

[Beacon]

I persumed he meant the product not the language!
I.e MS sql server!

[Hack]

A major factor in the decision on SQL Server vs Access would be the number of records your application will need to store and process. Access tends to dog itself when your record levels approach and enter 6 figures in number.

[texas]

The small project that I'm doing will never have more than
1,000 records. Also at the most 3 people connecting to the app.


Have you ever used MSDE?????

My last teacher seemed to love it.

[kaandorp]

MSDE is in fact exactly the same as Microsoft SQL server.
Only SQL server supports bigger databases and more concurrent connections.

But if you don't want to pay for SQL server, but you do want the functionality and performance you should go for MSDE.

Access is a better solution if you are creating a desktop solution...
SQL server/MSDE is better for a multiuser environment.

[crispin]

MSDE tops out at 1gb of data storage and 5 users though if that helps...

[PWNettle]

In reference to the other thread you posted (VB Q&A), I'd say use SQL Server - that way no user can move your data!

Paul