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?