Oracle vs msaccess -

I am needing to develop a quick database with forms to allow users to enter, change and query information.  I am familiar with MSAccess and linking to Oracle via ODBC.  Is there another way and would it be easy to use - to develop and what would it be?

Thanks in advance.
leezacAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
If you already know Access and can live with the limitations then use it.

You are likely then also familiar with VBA.  If so and you need more flexibility take a look at ASP.Net.

The other quick option is Oracle's Application Express (APEX).  There will be a learning curve here.
0
slightwv (䄆 Netminder) Commented:
I appreciate the points but are you sure you would not like to leave this open a while longer to get some other opinions?
0
leezacAuthor Commented:
Well - yes in fact I would like to reopen to see what other opinions are there.  Thank you.
0
leezacAuthor Commented:
What I am running into is that the users want a Web Form to view.  I am only an Access Developer and have developed a little in vb.net.  I get a lot of replies that I should use .net.  I think it would take a longer time to develop.  The users do not like the look of MS Access Forms, but I can make it look professional.
0
slightwv (䄆 Netminder) Commented:
If you have done a lot with Access then you are aware of the limitations in a multi-user environment.

So, using Access you would have to write a lot of code to account for this where a .Net app would just be error handling.

>>I think it would take a longer time to develop.  

Time is directly proportional to existing experience.  You then have to account for performance/nasties introduced by using VBA skills in a .Net world.

What I mean by this is you can write 'working' code but there may be more efficient/better ways that a seasoned .Net person would know.

I know enough .Net to be dangerous and have developed from Intranet websites.  The work but I by no stretch call myself a .Net developer.

I Google and take snippets and glue them together.  I then look at a seasoned coders code and go WOW, that is a LOT better than what I was doing...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.