944,196 Members | Top Members by Rank

Ad:
Mar 21st, 2007
0

App Dev in Access

Expand Post »
Hi,
Sorry for posting in Web Dev even though this is an App Dev question. We're looking at methods to create a new application. The application will be used heavily by about 20 people concurrently, it needs to be very user friendly and highly interactive.

IT have nominated Java/Python/.Net or similar as the laguage backing onto a MySQL database as their prefered method. Management has requested we look at using Access.


My question is two fold:
What are the pros and cons of using Access to develop a large-ish scale application?
To keep costs down would it be suitable (reliable) to have Access back onto MySQL, or is MS SQL more reliable from Access?

Thanks,
James
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
port80 is offline Offline
2 posts
since Mar 2007
Mar 22nd, 2007
0

Re: App Dev in Access

IT department's don't like MS access for a variety of reasons. One is that MS access is not the most secure option. Another is that amateurs, often one of the bosses! Create MS access databases, get stuck, and take the unfinished product to the IT department expecting it to be sorted!

MS access is ideal for getting your project up and running, it is a very fast and easy development tool, ideal for a quick and dirty solution. If the quick and dirty solution becomes more permanent, more sensitive, then it is possible to upgrade your access database to MS SQL.

It is not uncommon to have twenty users using a MS access database, it depends on what they are doing.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Uncle Gizmo is offline Offline
16 posts
since Mar 2004
Mar 23rd, 2007
0

Re: App Dev in Access

IT department's don't like MS access for a variety of reasons. One is that MS access is not the most secure option. Another is that amateurs, often one of the bosses! Create MS access databases, get stuck, and take the unfinished product to the IT department expecting it to be sorted!

MS access is ideal for getting your project up and running, it is a very fast and easy development tool, ideal for a quick and dirty solution. If the quick and dirty solution becomes more permanent, more sensitive, then it is possible to upgrade your access database to MS SQL.

It is not uncommon to have twenty users using a MS access database, it depends on what they are doing.
We would not be using Access as the Db, mearly as the front end. I would much rather see an application built around a progamming language rather than Access because I feel it would be more robust and offer more flexibility.

I have the task of explaining to Management why and I would like to use something more than just a gut feeling.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
port80 is offline Offline
2 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: How do you transfer a single record in Filemaker Pro
Next Thread in MS Access and FileMaker Pro Forum Timeline: Querying a Calculated Field?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC