what difference between access and sql. i use access in a database project not sql. what what problem i will faced for not use sql. or what advantage i will get for using sql.

Recommended Answers

All 6 Replies

sql Do you mean Microsoft SQL Server, or do you mean the SQL language?

if you mean sql server then in simple i can say sql server is an ORDBMS while access is not.

I mean microsoft sql server

now i learn sql is for multiuser and server.....what u suggest for me if i use access for a student database. like student record, or others record of a school.

Access is ok for one or two user database, but anything beyond that is just too much. For multiuser you need something like Microsoft SQL Server, or MySQL. For student projects Microsoft Access is IMO an excellent choice.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.