Benny Chang's Q&A profile

• Visual Studio Tools for Office Is VSTO-enabled protection of an Excel workbook stronger than regular Excel/VBA?

  I have a complex financial model in Excel that I have password-protected and I give users access to it through an Excel Addin - VBA opens the file and custom commandbar buttons enable subs that manipulate some of the data, allow the user to save certain data, etc. Sheets that I don't want users to see are hidden, other sheets are visible but cells are locked and input sheets have unlocked cells. Also the VBA code in the Addin is password-protected. I know that Excel and VBA security are weak so my existing setup, summarized above, will only prevent casual users from not accessing my model. So I am researching VSTO as a more secure alternative. I know that the VB programming code will be safe, but what about the Excel workbook If I creat ...Show All

• SQL Server Lock a table until Package execution finishes

  Hello, I need to lock a table in startup of my package so that access calls from other applications are put on "wait" by sql server until I unlock. Any idea how would I do it Or is it possible or not Thanks, Fahad You may want to jump over to the Transact-SQL forum to get help on this. I would imagine you can issue a table lock command in an Execute SQL task, and then when done processing release that lock in another Execute SQL task. ...Show All

• .NET Development assembly versioning best practise

  How can I find out how to control versions of assemblies in usefull way When should I increment wich part of the version nummer (major, minor, build, revision) Should the build part be incremented upon each build If so when should I increment the revision part The Visual C# compiler is capable of incrementing the revision part automatically. How does it decide by how much that version number gets incrementent by each build I noticed that this seems to be rather randomly. Also it seems that incrementation only happens if I delete the previously compiled assembly before next build. Why is that so How detailed can I control how the visual c# compiler behaves on versioning   When linking assemblies (when) does t ...Show All

• SQL Server Problem 2147749890 when installing SQL Express 2005

  I attempted to download SQL Express 2005 and received the following. Any assistance or direction to answers would be appreciated. The platform is Windows 2003 Web Edition, is a non Web Edition server required TITLE: Microsoft SQL Server 2005 Setup ------------------------------ The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine COMPAQ8 Error:2147749890 (0x80041002). For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=70342 ------------------------------ BUTTONS: OK ------------------------------ I've seen this kind of problem before, ...Show All

• Visual Studio Tools for Office MAPI Forms support - without Outlook

  HI, We have implemented MAPI to send and receive messages. The issue we are facing is that we want send the email using a custom form but MAPI fails when accessing FormManager of the profile with error code 0x80004005. Similarly, the MAPI Editor tool MFCMAPI does not load local Form Container and fails with the same error. This happens on a non-outlook machine but works fine if outlook is installed. We need to get this working in a non-outlook machine. has anyone done this or can help Thanks in advance chawlarachit I'm not sure I understand your question, could you reiterate You want to be able to send mail using your custom MAPI form on a machine without Outlook (and there for MAP ...Show All

• SQL Server Database engine tunning advisor and triggers

  Hi, I captured a trace using the profiler and provided the trace to the tunning advisor for analysis of the indexes. I am not convinced that it processes the triggers properly. I used the tunning template on the profiler and confirmed that the code from the triggers is captured. However, in the tunning advisor I am getting an error message like this: E000 INSERT INTO SP ( FkSID, FkRPID, FkSPStID, NPR ) SELECT SID, RPID, 0, NPR FROM INSERTED INNER JOIN RP ON INSERTED.FkCID = RP.FkCID WHERE 0 = INSERTED.IA 2 [Microsoft][SQL Native Client][SQL Server]Invalid object name 'INSERTED'. From the above it appears that the advisor does not recognise the "inserted" temp table used in an insert trigger. Is there anywa ...Show All

• Windows Forms adding single records to a gridview

  I have a cbolist the user will select a name hit enter then a query runs to get that name details and enters it to a grid view, the user clicks another name and its details are added. How do i do this. i have only used the adapter.fill(table) gridview1.datasource = table but only one record is showing the last one clicked. "seperate list holder" - you mean like a "storage container" which constantly has items being added (or removed) right Yup I agree and this is what I had also posted earlier. (sorry, just different termonoloy) :-) ...Show All

• Smart Device Development Connect with GPRS programatically for Pocket PC Client application

  Hi All, I am developing Client Server TCP/IP based application in VB.Net. My Client Application is Smart Device application and going to be run on PDAs. This Client Application will connect with my server via TCP/IP using sockets. My Server Application is win form based application and going to be run on our server. Problem: { My Client Application needs GPRS to be connected. So, if GPRS is not connected, we have to do it manually. I am looking for the way where i can first check status of GPRS and then if it is in disconnected mode, i can connect is automatically using code. } I searched on net for the same and somewhere I found about Connection Manager Class of Open Net CF. But i didn't get any exact way or code sample to do it. I als ...Show All

• Software Development for Windows Vista Local Communication service events in sequential workflow

  When is an event allowed by the local communication service When I'm waiting for an external event, I can deliver an event of the type that is expecting the HandleExternalEventActivity. That's the expected behavior. Now, for example, if a have a delay activity, then a code activity and then a HandleExternalEventActivity I can also deliver the event expected by the HandleExternalEventActivity while I'm currently in the delay activity. So, doing some tests, I realized that the events seems to be allowed to be dispatched if it exists a handleExternalEventActivity with the correspoding event type in whatever part of the workflow Am I right This behavior is completely different in state machines where only specified events are ...Show All

• SQL Server Firefox Issues in 2005...

  Can someone please verify that the following items are not supported in Firefox. Our app issues an http request to the report server (url access). The following differences are seen between IE and FF: 1) The message "Report is being generated" does not disply in FF during report generation. 2) The printer icon does not appear in the toolbar. 3) Is there any plan to support search functionality within the report in the future Thanks. Thanks Daniel. I'm recommending to my clients that the IE Tab add-on be installed in Firefox; it solves the problems with the search bar and also displays the "Report is being generated" message. I understand why the search bar functionality is n ...Show All

• Visual Studio Team System Would like to set condition when sequence of events happen

  I would like to make integration build required for developers when the state is set to resolved and the assigned to is "qa" How can I do this Thanks. If someone does not associate a work item with a check in, then the integration build will not be auto filled. So I would like to make sure that when they sign off bugs that QA knows which build to test against. Thanks, Jon ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3Ds Max Texture Error

  I'm having trouble getting textures to work in XNA with models that I've created myself. I went through the Space Tutorial and have no problems loading the provided models, or any other models i find elsewhere. However, when I try to use a model that I created and textured myself (in 3ds max, tried with Panda exported .X files, kW X-ported .X files, and .FBX files) I get a weird error. I do not think that the error lies in my code since it's a) basically straight off the tutorial and b) models other than mine work fine. The error points to this line of code: myModel = content.Load< Model >( "Content\\Models\\stripe2" ); It says: Argument Exception was Unhandled, Device does not support multi-level texture ...Show All

• Smart Device Development Error While Streaming files on the WM SmartPhone

  I was trying to stream an Mp3 file from a PC connected to the network to my Windows Mobile Smartphone. I got this error in windows media player. "Cannot play the file. The file is either corrupt or the Player does not support the format you are trying to play." It seems the possible error is Windows Media Player 9 Series does not support MP3 files that have unsynchronized ID3v2 headers. Earlier versions of the Media Player ignore the header if it is unsynchronized. Can you expalain how to get rid of this error. Is there a fix for it. regards, shailender This forum is primarily monitored by Visual Studio for devices group. Please check this link for ...Show All

• .NET Development Missing DWMAPI.dll causes problem with COM interop in c#

  I have recently installed IE7, and am now experiencing a problem with COM interop in one of my c# projects. It seems that there is a dependency on a dll called DWMAPI.dll from the COM dll. I have read a bunch of posts about similar problems, and it seems this dll comes with Vista, but is missing on XP machines. For some reason, installing IE7 makes it become a dependency for things like .NET interop. The only solution I have been able to find in the forums and posts is to uninstall IE7. Microsoft has not yet posted anything that I could find in regards to this issue. Does anyone know something I don't Any help is greatly appreciated. Thanks, Dan Well, as long as you know what's going on. There's ...Show All

• SQL Server ClickOnce for SQL Express Database?

  I'm working on an app in Visual Studio 2005 that needs to have installed locally SQL Express to handle its own data. This app is in a strong upgrading process. I've been using clickonce to publish the app and let my users upgrade automatically (by the way this works amazing ...). Yet many times changes to the DB are made. Is there a simple way to upgrade their local SQL Express DB like click once does with the app Thanks. hi, I'm not sure about click once capability to perform the requested task, but even if possible, are you sure you like to do it that means you would upgrade users database loosing their data modifications... I do think you've better just "upgrade" the database ...Show All