Recent content by VB400

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

Rudy, what is XXX? Tarek

Thanks Rudy, No that was just sample data for the thread. You did make me smile though [thumbsup2] Tarek

Thanks MeanGreen. I'll try that. Is there anyway to do this in a SQL statement rather than an Stored Procedure? I will need to do something similar in Access. 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...

Swi, You didn't address the problem with Permission Denied! Regardless of New vs. CreateObject, the Permission Denied is still the problem. Thanks anyway! Tarek

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...

So, eventhough it was trial and error on my part, it seems to have been the right solution in this case! -- I knew that -- X-) Thanks for your help Terry Tarek

That didn't seem to help! However, I changed the index to be clustered and that made all the difference in the world. Is this the right thing to do? I'm new to SQL Server so I'm not yet familiar with the "Standard Operating Procedures". It is my understanding that you can only have...

Terry, I just did that and there is a difference: When I use "=", SQL Server uses Table Scan When I use "Like", SQL Server uses Index Seek, Filter and Bookmark Lookup Why is this happening? Tarek