I think by sql here u mean MS sql server, that's why u r comparing it with access.
Access only serve as desktop database. When it comes to client/ server or distributed or large databases MS sql srv or other such databases are used. Access also don't have all the features of MS sql srv. It differs from data types to level of security, transaction mgt. etc. Study the differences carefully.
No doubt access is simple but it is only used in case of simple, desktop applications and practicising examples.
Why sql is best ? access cantain max feature of sql and coding of vb.?
Eh? Sorry, can't understand the question or what you want to find out.
Please try again but explain more completely.
Reply:Additionally to the differences well explained by "Friend" I will add the following:
Access is less stable, an access database will get corrputed easier than an ms-sql database.
Access doesn't release unused space, only shrinking database you can release that space.
Access has file size limitation.
Access does not support stored procedures, an Access query is like a parametrized view. Only one statement can be executed in an Access query.
These just to mention a few differences.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment