Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 15th, 2007, 11:15 AM
Friend of Wrox
Join Date: Sep 2005
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Corey
Default Oracle back-end MS-Access 2003 client front-end

Hello everyone. The company I’m working for is looking to convert my MS database into a Oracle database.
Can anyone tell me the advantages and disadvantages of a Oracle back-end with a MS-Access 2003 client front-end



Old February 15th, 2007, 03:42 PM
Friend of Wrox
Join Date: Jan 2007
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to scandalous Send a message via MSN to scandalous


I have a very limited knowledgebase to give effective advise on the subject but here is what my thought is.

Using the backend as oracle will allow more traffic (Simultaneous users) and a larger recordset (more than 50MB or what ever the suggested Access DB size is) to be stored. I would think of it like upsizing it to SQL Server. My company is doing the samething with what I am making but they want it on thier intranet. Using MS Access is as a front end is logical because implementation is easy to use and manipulate data.
Well thats as much as i can tell you LOL.

Old February 16th, 2007, 08:31 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

You should be able to use Oracle as a back end, but you will probably want to use a DSN to connect to it. This is a little slower than provider statements, but probably safer since DSN's are essentially a service and Access doesn't care what is on the other end.

You will also want to make sure that your data types are correctly aligned between the Access front end and Oracle tables.

Are you using local tables with datasets from Oracle, or linked tables?


Similar Threads
Thread Thread Starter Forum Replies Last Post
Front end Vs Back end ricmar Access VBA 3 May 27th, 2008 02:36 PM
Ms Access front End with Oracle 10g Back End rahul123 Oracle 1 July 9th, 2007 01:03 AM
Oracle Back End - MS Access Front End - Multi User ckaliveas Oracle 1 February 1st, 2007 06:00 AM
Re-linking the front and back end Scripts82 Access VBA 2 February 24th, 2006 12:26 AM
using msde and sqlserver with access front-end catkins Pro VB 6 1 April 1st, 2004 04:00 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.