using Oracle as backend for Access

[Djblois]

I posted this question over at VBAexpress yesterday (which I should have posted here first because their Access forums is not as active as here) and was wondering if anyone had an answer:

I have written a few solutions in Access (using access 2007). Now I going to create a few new ones for my company. We use Oracle for our main database and was wondering what would be the advantages and disadvantages of using Oracle as my backend while Access is my front end?

Also, should I create the queries in Access or in Oracle?

finally, is there anything I need to do differentely?

Here is the link:

http://vbaexpress.com/forum/showthread.php?t=4602

 

[Djblois]

Pat thank you for the reply.

A few clarifications, when I asked what benefit I meant what benefit would I receive by using Oracle as the backend instead of an Access (.mdb or .accde) backend. Is it worth the hassle?

This new database I am going to be creating is also going to have attachments, therefore it will get quite large.

Also, do you know of a good resource either a book or a website that will help me with the Oracle and Access integration?

 

[jdraw]

Do you have a DBA area? Have you discussed your use of Oracle vs Access with them?
Does your company's main business run on Oracle (finance, HR...)?

Perhaps you could tell us about your proposed use of database. Will it be transaction processing, multiuser, multisite...?

You haven't told us much about your needs.

 

[mdlueck]

I have written a few solutions in Access (using access 2007). Now I going to create a few new ones for my company. We use Oracle for our main database and was wondering what would be the advantages and disadvantages of using Oracle as my backend while Access is my front end?

Also, should I create the queries in Access or in Oracle?

finally, is there anything I need to do differentely?

I am headed out for the day, just saw your post, so pausing to share this link since you are considering Access in a Client/Server environment:

Client/Server Architecture
http://www.access-programmers.co.uk/forums/showpost.php?p=1110794&postcount=5

 

[Djblois]

Pat, the amount of users at one time will be anywhere from 5-30. I am more concerned with the amount of data. What I am creating is a Customer Complaint Database that people can upload attachments and keep a log of correspondence with the customer from emails to word documents to excel, etc..