Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PalaniappaBabu

    Determining the version of MS-Access through Code

    How do I determine, through ADO, what version of MS-Access (97/2000) am i opening?
  2. PalaniappaBabu

    Database Compacting Problem

    Yeah.... The problem is with Jet OLEDB Engine Type. The value must be 5 instead of 4 since i am using Microsoft.Jet.OLEDB.4.0 engine. The CompactDatabase statement must be like jet->CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data...
  3. PalaniappaBabu

    Database Compacting Problem

    Yeah.... The problem is with Jet OLEDB Engine Type. The value must be 5 instead of 4 since i am using Microsoft.Jet.OLEDB.4.0 engine. The CompactDatabase statement must be like jet->CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data...
  4. PalaniappaBabu

    Database Compacting Problem

    I am trying to compact a MS-Access database using the follwing piece of code which is in Visual C++/JRO : try { CoInitialize(NULL); IJetEnginePtr jet(__uuidof(JetEngine)); jet->CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data...
  5. PalaniappaBabu

    Database Compacting Problem

    I am trying to compact a MS-Access database using the follwing piece of code : try { CoInitialize(NULL); IJetEnginePtr jet(__uuidof(JetEngine)); jet->CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nSamp.mdb","Provider=Microsoft.Jet.OLEDB.4.0;Data...
  6. PalaniappaBabu

    Insert Tables from another Database

    Pls try this..... Dim cn as ADODB.Connection; cn.open("apple.mdb") sql = "SELECT oldTable.* INTO newTable IN 'banana.mdb' FROM oldTable" cn.execute(sql);
  7. PalaniappaBabu

    Select two fields from different MS-Access Databases

    The problem is there must not be any joins (i.e, I must not create any joins). I have to do this with a SQL statement. Is it possible?
  8. PalaniappaBabu

    Select two fields from different MS-Access Databases

    Is it possible through a SQL Statement? For Ex : Select a.No, b.Name from db1.Employee a, db2.Employee b;
  9. PalaniappaBabu

    Select two fields from different MS-Access Databases

    Is it possible to Select two fields from different MS-Access Databases?
  10. PalaniappaBabu

    How can I import/export from a SQL database some data ?

    Use ADO, which has been recommended by Microsoft to deal with databases from Front-Ends. You can use _ConnectionPtr, _RecordsetPtr. Please check this tutorial which will be very useful for you getting an Idea about ADO. http://codeguru.earthweb.com/mfc_database/Ado_Aok.shtml

Part and Inventory Search

Back
Top