effiecient ways of data access 
Author Message
 effiecient ways of data access


>Hi everybody, I am developing an application in VB with Oracle 7.x as the
>back end. Presently, I have attached all my tables to Access DataBase. I
>understand that there are several ways of accessing external databases
>i.e using data controls, data objects, rdos etc.  I would like to know it
>attaching is a good thing to do (although it might depend on the
>application under question)? If not, what is more efficient ? I would

You will need to associate the DAO 3.x language extensions to your project,
then just open the data directly through ADO or ODBC calls directly
to the Oracle Database.

Attaching them to Access will make Jet do all of your database calls,
which is inefficient and prone to incompatability with the real power of

- Code Gurus: Custom solutions programmed for your business.
- Fair rates, fast response, rock-solid code. Initial consultation free.
- Visual Basic, Relational databases, Java, Internet programming, we do it all.

Fri, 19 May 2000 03:00:00 GMT  
 [ 3 post ] 

 Relevant Pages 

1. Sending data both ways with MS Winsock control

2. Other easier simpler ways to access a mdb file from VB

3. Help - Simply Getting Data from Extrenal Data Files (not from Access Data Base)

4. Ways to code - Performance

5. Different ways to open a Recordset

6. CreateObject seams to be slow, any ways to improve performance

7. All the possible ways to create an attachment

8. 2 ways to write a macro

9. Any Quicker Ways to Populate a Dropdown?

10. Any ways to make focus on Label control like focus in button control

11. The strange ways of .net, !!!References!!!

12. Sort a test 2 ways: by student/answer


Powered by phpBB® Forum Software