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

Thanks

Corey

Corey,

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.

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?

mmcdonal