473,320 Members | 1,977 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

When should one use Access over a more robust database?

Niheel
2,460 Expert Mod 2GB
When should one use access over a database like SQL Server or MySQL ?
Oct 23 '10 #1
7 2287
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

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

Similar topics

3
by: cooldv | last post by:
i am running a website on Windows 2000 server with ASP 3 webpages and Access 2000 database. (with a hosting company) traffic is slow at this time but expect to grow. lately i have been reading...
17
by: Rebecca | last post by:
I have a large Access 97 database that's been split into a front and back end. We've used it successfully with several computers networked together, but now some of the people in my organization...
3
by: Terry Block | last post by:
We have an Access 97 database app that we'd like to enable (not convert) for Access 2003. We still have users running 97 and are not prepared to upgrade everyone who uses this database to the 2003...
4
by: ronald balk | last post by:
Dear people, after many efforts I'm putting my hope on you. Last week I changed a lot of forms and reports in an Access 2000 database. It all worked fine and I closed the database without any...
3
by: Chris Williamson | last post by:
Hi, Currently I am working on a Visual Basic program that makes use of an Access database produced under Japanese Access '97. The program works correctly on Windows 2000, however when it is...
0
by: dlieu | last post by:
I've found an odd situation in where the Load event of the active form fires (after the Unload event) when Access is closed. I am able to reproduce this situation in Access 2002 SP3 and Access 2003...
5
by: Chand | last post by:
Private Sub tbDate_AfterUpdate() Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset rst.CursorLocation = adUseClient Set cnn = CurrentProject.Connection rst.Open "SELECT * FROM...
5
by: Al | last post by:
Hi, I am looking for sample VB.net code for working with Access 97 database. I know how to work with SQL but I dont know how to read and writ into access 97. Any help is very much appreciated. ...
4
by: StefanSerena | last post by:
Hi I'm running Windows 2000 and Office 2003. I want to copy tables from an unknown database format into Access 2.0 and I could do it quite easily if it weren't for the fact that recent...
2
by: suzanne | last post by:
I have a database that had been stable until 3 weeks ago. The Access 2003 database occasionally (a couple of times a week) gets corrupted when the last user exits the application. At least, that's...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.