Search results for query: *

I'm getting the message: -2147217900 Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. I have one component running in COM+ which is defined as "Requires Transaction". First call I make to the component, it works without a...

In an effort to minimize network traffic, we're thinking of offloading some database table access to each individual desktop (this is NOT a web based app and there is no intention of making it so). This would only apply to static tables that hardly ever change such as "State&quot...

An employee who recently left the company, had all of his work documents password protected. We're trying to access these documents but we don't know the passwords and unfortunately, this person did not leave on good terms. Is there anything we can do to open these documents? Tarek

I have a Customer Transaction table where each customer has many records. How do I return just the last 3 transactions for each customer? Say I have the following simple table CustID Date 1234 01/15/02 1234 02/16/02 1234 02/17/02 1234 02/18/02 4567 01/15/02 4567 02/16/02...

I have a VB program that is setup to run via Windows NT's Scheduled Tasks. The program basically generates a report that we want to print at night and have it ready on the user's printer first thing in the morning. When setting up the Scheduled Task, we give it an account name and password...

I'm having a problem with the following code: objPB.WriteProperty "UserName", .Fields("UserName") This gives me the following error message: Run-time Error 330. Illegal parameter. Can't write object because it does not support persistence. When I add the .Value property...

This works fine on a Win/NT box; however, I have a client who needs this code on a Win/XP box using VB6 and Office 97. Make a reference to "Microsoft Word 8.0 Object Library" Dim objWordApp As Word.Application Set objWordApp = New Word.Application The last line gets...

I login as a Power User on a Windows XP box. My package is installed in COM+. When I start my front-end program, an error window is displayed "Permission to use object denied". I logout of Windows and login as Administrator and the application runs just fine. I researched this for...

I have a query that selects records based on LastName and FirstName (the table has an index by LastName, FirstName): SELECT * FROM CUSTOMERS WHERE LastName = 'Smith' AND FirstName = 'Susan' This takes an average of 24 seconds to return 88 records If I change the SQL statement to: SELECT *...

This question may have been asked before but "Search" is down. We're looking for installing ISDN to our remote sites as a backup to our T1 connections. I've heard in the past that DCOM doesn't work over dialup. Does anyone know if DCOM runs over ISDN? Thanks in advance! Tarek

When I double click on a section, it takes me to VB code as follows: Private Sub Section3_Format(ByVal pFormattingInfo As Object) End Sub It made sense to me that I can format data here before it prints. For example, I thought I'd be able to format a phone number before printing or other...

We have our internet site (mainly for webmail) and our intranet site on the same Win2000 server machine running IIS5. From the web, a user accesses our site via http://webmail.ourcompany.com which will present a "Microsoft Outlook Web Access" signon screen. The user then logs in to...

Can I use PropertyBag Object in VBScript? If so, How? When I tried using it, I get a "Class not defined: PropertyBag" error! Dim objPB Set objPB = New PropertyBag objPB.WriteProperty "Name", "Testing" Set objPB = Nothing Tarek

I have a Business Object in a DLL that returns a recorset object. Usually, I have a VB front-end that receives the recordset object and displays it in VB forms. I have a new requirement to display the same recordset but on a web page (intranet) instead of VB forms. Here's the code that I...

We're having a problem with IIS 3.0 running ASP pages . When a user within our domain tries to access any ASP pages, they're forced to provide a user id and password (all users except administrators). They get message 401.3 After doing a bit of research, it looks like IIS creates a user id...

I have a simple ASP page on my server. I can access the page from any PC on the network as long as I'm signed on with administrative rights. However, normal users get 401.3 error "Not authorized due to ACL..." . I checked the directory from windows explorer and it has among other...

Does anyone know what this message is all about: "An ActiveX control on this page might be unsafe to interact with other parts of the page. Do you want to allow this interaction?" This error occurs while I'm running inside of FrontPage at the line where I'm creating an instance of a...

I have a bunch of data coming from a recordset that I need to display on my page. I'm thinking of using a table but I don't know how to reference a table via code. I know for text fields you use document.formname.textfield.value but how do we reference a table and its cells? Also, can we...

I want to start using XML. I'm currently programming in VB6 on NT workstations. I hear that XML is the way to go but I'm not sure if it is available for me now or do I first have to upgrade to Win/2K. Also, can someone recommend a book for this! Thanks in advance! Tarek The more I learn...

I just created a simple HTML page using Word. From the Windows Explorer, I can double click the document and it opens up without a problem (I'm using ie5.5). If I first open ie and try to open it using File -> Open, I get the error: "Access to the resource 'c:\test.html' has been...