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.
abu taher 34 Practically a Posting Shark
Ancient Dragon 5,243 Achieved Level 70 Team Colleague Featured Poster
sql Do you mean Microsoft SQL Server, or do you mean the SQL language?
debasisdas 580 Posting Genius Featured Poster
if you mean sql server then in simple i can say sql server is an ORDBMS while access is not.
abu taher 34 Practically a Posting Shark
I mean microsoft sql server
venkatramasamy 1 Junior Poster in Training
HI,
Similar thread is posted with the Title of "MS Access vs. MySQL"
click the below link to visit the thread
http://www.daniweb.com/forums/thread5712.html
Hope this will help you.
With regards
Venkatramasamy SN
abu taher commented: thank you for details help +1
abu taher 34 Practically a Posting Shark
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.
Ancient Dragon 5,243 Achieved Level 70 Team Colleague Featured Poster
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.