hello, My MFC application is getting crash because of some message,i don't know which message.Is there any way to track the message which is causing crash? Thanks.

Hello, I am using a third party vendor's grid in my application.When I create a dynamic combo box on the grid,and drag an item to the grid outside the combo box rectangle,a crash occurs.I hav no idea which message is causing crash. Any help would be appreciated. Thanks

Hi all, i am generating a word report using OLE Automation.It has all the things that a Detailed report can have from Header to footer.I am using mail merge to populate the data in the report.This data i am fetching from an access database. My problem is with table of contents.The main document with all the fields contain the table of contents.This table of contents is not being merged in the new merged document.It is displaying it like a normal text (not TOC Field) and showing values with mergefields name(not values) in the headings(the headings do have some mergefields in them). Did anybody work on similar thing. Please help me regarding this.

Hi, thanks for reply. I am new to databases,so i am not able to implement your suggestion into code. I am sending my present code .It will be of great help,if you show me direction from here. CString sDriver; sDriver = _T("MICROSOFT ACCESS DRIVER (*.mdb)"); CString sDsn; sDsn.Format(_T("ODBC;DRIVER={%s};DSN='';DBQ=%s"),sDriver,sInstallDir + _T("\\v010\\Program\\MDD.mdb")); if(!m_pDatabase->IsOpen()) { m_pDatabase->Open(NULL,FALSE,FALSE,sDsn); } ............................................................. //HERE I NEED THE CODE TO CHECK WHETHER THE DATABASE HAS ANY TABLES ,IF YES ,I NEED TO DELETE THOSE TABLES. .............................................................. I DON'T KNOW HOW TO GET CONNECTION OBJECT HERE BECAUSE I DON'T FIND ANYTHING LIKE CONNECTION OBJECT WHILE USING ODBC,CDATABASE AND CRECORDSET CLASS. .................................................................... ANY HELP WILL BE GREATLY APPRICIATED. .......................................... THANKS AND REGARDS.

Hi, is there any way through which i can check into the Access database wheteher the table is created or not?

Hi group, I am sure that in my last message ,i couldn't explain the problem clearly.So i am writing the message again. Actuall my application is acting as a OLE Automation client to MS Access.It uses Access application object's TransferText method to transfer a text file into a table in a mdb database.Now ,in the next statement in my client application ,i want to know whether the table-loading is completed(as it is a separate process and TransferText returns immidiately after firing the command).If yes,i will run some Table-dependent code.But i don't know a way through which the MS Access Application can notify me that the Loading operation is completed. As this is a crucial issue, i need expert's help.... Thanks and regards.

Hi group, I am using OLE to interact with MS acces ,to import a CSV file into a table in the database.I am using Access Application object and calling its TransferText function to do it.As it runs into a separate process,i am facing a problem.My program is using this table,so i must know ,when the transfering operation is completed,and ensure that all the database dependent operations are supende till than,is there any method to do it? Could the experts give any idea?

Hi, can any body help me in creating a username and password for the database programmatically.I am connecting to the database like this: CString sDriver = "MICROSOFT ACCESS DRIVER (*.mdb)"; CString sDsn; TCHAR sError[100]; sDsn.Format(_T("ODBC;DRIVER={%s};DSN='';DBQ=%s"),sDriver,sDatabase); try { m_pDatabase->Open(NULL,false,false,sDsn); } catch(CDBException* e) { e->GetErrorMessage(sError,100); AfxMessageBox(sError); } :confused:

Hi davi , Thanks a lot for guidance. Regards.:)

Thanks a lot Jens, I solved my problem.

Hi all, I am writing a program that requires deleting a file stored in the disk programmatically .I am wondering if we can do that? Could somebody help me on this. Regards.

HI, I HAVE A COM DLL DTSPKG.DLL WITH ME.I WANT TO USE ITS INTERFACE ,I ABSOLUTELY HAVE NO IDEA ,HOW TO DO IT.I NEED HELP... THANKS AND REGARDS.

Thanks all,i solved the problem using CRecordset.

hi Daniel, Thanks for quick reply. Actuall i am running the Query-- database.ExecuteSQL("SELECT MAX(dist) FROM TempTable"); and i want to get the result in a local variable that is declared inside my function .I want to assign the value of MAX(dist) into this local vaiable. something like this... int local; local = database.ExecuteSQL("SELECT MAX(dist) FROM TempTable");//I Wish i could be able to do that. Can you help me in achieving this. Regards.

hi all, i am trying to run a query like this ---- CDatabase database; CString sDriver = "MICROSOFT ACCESS DRIVER (*.mdb)"; CString sDsn; CString sFile = "c:\\MDD.mdb"; sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile); TRY { database.Open(NULL,false,false,sDsn); } CATCH(CDBException, e) { } END_CATCH database.ExecuteSQL("SELECT MAX(dist) INTO temp FROM TempTable"); *********************************************************************** TempTable is a dynamically generated temporary table.My problem is that i need to get the result of the above query into a variable. any help to solve this problem will be appreciated.... Thanks and regards.

hi, I am trying to import a tab delimited text file into an MS Access database using transferText function.This transferText function needs the import Specification name for creating the table.It specifies the format ,number of columns ,columnnames etc.We can do it manually in MS Access using import wizard's Advanced button.But in my project requirements are such that the user won't be manually creating the specification. I ask help of all the experts to help me create the specification programmatically.It's Quite urgent. Thanks and regards.

Hi friends, I think an Article showing automation of MS Acces that imports a flat file and turn it into An ACess table is needed.

hi, can anybody tell me ,how to use MSDE with MFC applications. Any help will be highly appreciated. Thanks and regards.

HI, THANKS FOR REPLY.BUT I COULDN'T UNDERSTAND YOUR SUGGESTION PROPERLY.WHAT DO U MEAN BY EXTERNAL LINK?HOW IT IS CREATED ,CAN U TELL ME THROUGH A SMALL SAMPLE CODE? THANKS AGAIN.

Hi , I am searching for a good sample code or article that takes a tab delimited file as input and imports it prograamatically in an access database.I don't want to loop through all the records in the text file and then put them individually into access.I want to import the whole file programmatically into an MS ACCESS table.May be it requires OLE. Any help will be appriciated. Thanks and regards.