469,138 Members | 1,284 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,138 developers. It's quick & easy.

When should one use Access over a more robust database?

Niheel
2,429 Expert Mod 2GB
When should one use access over a database like SQL Server or MySQL ?
Oct 23 '10 #1
7 2034
Access should be used when you are designing an application that is essentially a management or control system. These applications generally don't have a huge amount of records and access allows for the easy design of a user friendly interface.

However, the question is not just an either/or. Access can be used to design a user friendly interface over any of these SQL based systems.
Oct 23 '10 #2
MMcCarthy
14,534 Expert Mod 8TB
I agree with the points Anne has made. Access is perfect for small management type applications. It is also ideal as the means of designing a User Interface that is both easy to design and user friendly.

Mary
Oct 23 '10 #3
MMcCarthy
14,534 Expert Mod 8TB
I should also make the point that you would use odbc drivers to link to the data structure in MS SQL, MySQL, etc. when using access as a frontend GUI.
Oct 23 '10 #4
Access has the best user interface, I agree. Just also wanted to point out that Access is a full SQL database and can be used as such as long as you follow normalisation standards. You can store a lot of records in Access these days before it becomes a problem so it's really suitable for a lot of business applications.
Oct 23 '10 #5
MMcCarthy
14,534 Expert Mod 8TB
Great points Peter. Access is not given enough credit as an rdbms system.
Oct 23 '10 #6
MMcCarthy
14,534 Expert Mod 8TB
Access is also extremely powerful because you have the use of VBA (Visual Basic for Applications) which allows you to do more than just program events. It allows you to manipulate the API, build your own classes and interface with numerous other applications with the use of libraries.
Oct 23 '10 #7
Yes Access really doesn't get enough credit for the powerful development tool that it is.
Oct 23 '10 #8

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.