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?