Hi All,

My application supports Access, SQL Server, MSDE and oracle.
Some porion of code is in VB and some of it is in C.
For C I am using ODBC calls to make entries in the database.
For VB i am using ADO.
In case of oracle, SqlServer, MSDE there is no problem but in case of
Access ODBC calls seems to be slow. See the following code

See the following piece of code

// at_DB_insert uses ODBC calls to insert data in database
// Adding data through vc
if (at_DB_insert (pDbHandle, AT_PROJECTDB_DOCREG_TABLE, m_pDocData) == AT_DB_SUCCESS)
{
    // GetDocIDFromFileName is written in VB and using ADO
    // We now want to read the entry made in database through VC above
    // Try to read it through VB. In case of oracle it takes less
    // then a second but in case of Access it takes 3-6 seconds.
     while (!(pDocID = GetDocIDFromFileName (documentFileName)))
       Sleep (500) ;

}


Any help is appreciateable.

Regards,
Salman

Why not just use ADO with Access? I am not sure about your question either, but, ORacle, SQL Server and MSDE are all true client server databases, access is not, therefore it will be slower.





Sal