By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,306 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Oracle back-end MS-Access 2003 client front-end

P: 6
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
Feb 15 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Hi Corey,

This is actually a good and often used combination. If the database is not large in size then Access is sufficient. However, if the data storage is going to exceed a gigabyte in size (records in the millions rather than the thousands then a SQL back end of some description is required. The things you should take note of are that an odbc connection will be required. Also there will be some datatypes available in Oracle that won't have an exact mirror in Access and will be translated. This shouldn't be a problem just something to be aware of.

Mary
Feb 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.