Hi I am unable to open HELP from my visual studio environment. As soon as I click on any of the menuitems (contents, index etc) under HELP, the cpu shoots to 100% and it just sits like that.. I have also noticed that its allocating more and more memory, but the help window does not open at all. MSDN was properly installed and it was working just fine before. I don't recall to have changed any of my settings. I have already tried uninstalling/re-installing MSDN couple of times but no luck. Any clues. Thanks

I have a COM DLL built with VC++6 and it has dialog resources using activex controls such as MsFlexGrid and CTreeCtrl etc. I have two main applications(AppSimple and AppWithLotOfDlgResources) that can use this dll. When I use AppSimple to call this Dll, it works fine both in Debug and Release modes. The problem is when I use AppWithLotOfDlgResources application as the calling program, I am getting "Unsupported operation" only in RELEASE build. Q. Is there some kind of a conflict in resources between the DLL and the AppWithLotOfDlgResources ? Please help Thanks

ACCESS2000, ADO with VC++ I need to insert 500 records into a table. I am executing the following query for each record in a loop.. ///////////// PARAMETERS vID Short, vMRad IEEESingle, vQual Byte, vType Byte, vCRad IEEESingle, vWID Long; INSERT INTO PostODData ( OID, MRad, Qual, Type, CRad, WID ) VALUES (vID, vMRad, vQual, vType, vCRad, vWID); ////////////////// This insertion takes about 5 secs on a 400Mhz computer and I need to cut the time down to 1 sec or smaller. Any suggestions how to improve. Is it possible to send the parameters for all 500 records in an array . Does it help ? Thanks

Could you please help me in with a small sample code. Do I have to send the records as an array and loop the INSERT statement for all records? I am not quite sure if all this is possible in ACCESS. I guess my question would be can I pass an array to Stored proceedure, if Yes how? Thanks for your time.

I would have to insert around 500 records every 10 seconds into a table in Access 2000. I am using ADO. What is the most efficient way to do this with good performance. Is it possible to pass all of the 500 records to a query using some kind of SafeArray parameters and Insert them all at once? Any tips how this can be accomplished ? Thanks

How to inform in/out or precision and scale in argument list of Execute method. Thanks

Using Access 2000 and ADO VC++6.0 I am executing the following statement.. VARIANT Params[2]; Params[0].vt = VT_I2; Params[0].iVal = 1; Params[1].vt = VT_R4; Params[1].fltVal = 8.99; m_pCommand->adCmdText = "Query4"; m_pCommand->ActiveConnection = m_pConnection; m_pCommand->Execute(0, Params, adCmdStoredProc); Generates an exception {DB_E_PARAMNOTOPTIONAL} Query4 in Access is as follows: PARAMETERS vID Short, Rad IEEESingle; INSERT INTO TABLE1 ( ODID, MeasRadius ) VALUES (vID, Rad); Thanks for your help in advance.

Using Access 2000 and ADO VC++6.0 I am executing the following statement.. VARIANT Params[2]; Params[0].vt = VT_I2; Params[0].iVal = 1; Params[1].vt = VT_R4; Params[1].fltVal = 8.99; m_pCommand->adCmdText = "Query4"; m_pCommand->ActiveConnection = m_pConnection; m_pCommand->Execute(0, Params, adCmdStoredProc); Generates an exception {DB_E_PARAMNOTOPTIONAL} Query4 in Access is as follows: PARAMETERS vID Short, Rad IEEESingle; INSERT INTO TABLE1 ( ODID, MeasRadius ) VALUES (vID, Rad); Thanks for your help in advance.

I have around 500 records to insert into a table in Access 2000. I am using ADO. Is it possible to pass all of the 500 records to a query using some kind of SafeArray parameters and Insert them all at once? Any tips how this can be accomplished ? Thanks

How can I setup runtime ADO with minimal files / registration. I would like to distribute the runtime files with my application. What files are needed ? Thanks

How to do it programatically ? Any solution to "Autonumber" field running out of limits ? Thanks

Working with Access 2000 Database and ADO(Visual C++) My Database tables and their relationships resemble a Tree or a Family tree. (ie a lot of one-to-many relations between father/child tables) The task is to keep the size of the database within certain limits. As the database grows beyond certain limit, i would like to keep the latest N records and delete the old stuff. Unfortunately, this doesnt seem to reduce the size of the database (I don;t know why) may be because I am using "Autonumber" fields. The second step would be to reindex my autonumber fields so that I don't run over the limit of long integer datatype. Please help with some tips on how to approach. Thanks

Perfect. Thanks a bunch.

I am Using ADO(Visual C++) and Access 2000 database. Trying to limit the number of records returned by the recordset with PutMaxRecords(x), and the recordset returns all records. Thanks for your help in advance.

I am using ADO and have the following queries in my database Query: GetPW SELECT [PW].[Number], [PW].[Status] FROM PW WHERE [PW].[id]=CCID; Query: GetPR SELECT [PR].[Number], [PR].[Status] FROM PR WHERE [PR].[id]=CCID; Query: GetPWPR PARAMETERS CCID Long; SELECT * FROM GetPW LEFT JOIN GetPR ON [GetPW].[Number]=[GetPR].[Number] ORDER BY [GetPW].[Number]; When I execute query "GetPWPR" from within access, It works fine. (ie Prompts for CCID input value and returns records from PR and PW as expected) However when I execute using ADO::Execute command it fails with the error "IDispatch error #3127" (DB_E_NOTABLE) Any clues ? Thanks

Hi I need to resize MSChart programatically (when a user double clicks on the chart). I donot find the SetWidth(), SetHeight() functions. Any ideas how to do it? Thanks

No features from external libraries added. No custom implementation added. I soon as I finish with the wizard, I tried to compile. Thanks.

Really appreciate you taking time and explaining. Thank you. I have created this COM component using the wizard. After the wizard is completed I have not added any methods or any code manually to this project. I simply compiled it and that's when I get this message. So If I understand your feedback correctly, some of the libraries that the the project has linked are missing or cannot load.. How can I investigate which Dll is having problem with ? Thanks once again.

I tried putting a break point in DLLRegisterServer but it doesnot stop there.. Just to clarify once more this error is poping after linking while registering ActiveX Control.. Thanks

I have just created an empty COM DLL with support to MFC using VC++5.0. When complied, it fails to register. Regsvr32: LoadLibrary(".\Debug\testxyz.dll") failed. GetLastError returns 0x000003e6. I looked up for the error message and it is "Invalid access to memory location" Thanks for your help in advance.