Search results for query: *

Trying to capture output from DBCC SHOWCONFIG WITH ALL_INDEXES to a file. I have seen examples using 'EXEC ...xp_cmdshell...' that allows output to a file, but access to the shell is blocked for security reasons -- and I don't want to enable it. Is there some other way to get the statistics...

We are testing a new release of an application developed with Access-2000, but find a very severe performance problem when the application is launched by a VB6 program that issues a SHELL command. When launching the application by double-clicking in Windows Explorer, one screen will load in 2...

Hello, We have 70+ servers that are going to be renamed this fall. Our tech folks say they will provide us with a variable named like %ServerName% that our application can use. I'm afraid I don't know how to use something like "%ServerName%" directly in code, but I do know how to read values...

Hi, Don't laugh, but HP is telling me that they will most likely have to reformat my hard drive when they replace the motherboard. If you agree, I'll slink away... Background: New custom built PC from HP - 3 weeks old. Last night their "HP Updates" program ran, downloaded a BIOS update, started...

Hi All, Is there any way to set the connect string for a linked table to a path that is currently not available? When we deploy our application, the database tables will reside at "\\server\company\finance\backend.mdb", and we create that link using our "testing lab environment". However, our...

Hello, Is it possible to have my Win-XP-Pro computer think the following url is valid: \\server\foldera\folderb\ The problem is that when we deploy MS-Access to our sites, our MDE has linked tables to a database in the above URL. But to do that, we must go to our test system that actually has...

I have a server with a scheduled task set to run at 5:00AM each day, but when you look at the "Scheduled Tasks" window, it shows "0xc0000142" in the "Last Status" column. I've searched for hours with no success, so I'm hoping someone here has seen this. It is NOT due to the password changing...

Greetings, I'm responsible for maintaining a VB6 program that is encountering "Error 7 - Out of memory" in one subroutine. Although this application is deployed to 72 countries and runs on both XP and Win-2K servers, the problem happens only at one country, which is running Win-2K. The...

I would appreciate ANY code to provide network bytes sent and received from Performance Counters on a workstation (or is there another place?) Thank you for your assistance. "Have a great day today and a better day tomorrow!

The quick answer would be 2005, but.... On my laptop from work, I have Visual Studio 2003 and there are no plans to move to 2005 any time soon. At home, my personal PC has Visual Studio 6 and I would like to purchase my own copy of .Net. If I later develop VB code in 2005, can I at least...

Does anyone have code that I can insert into VB6 to list all processes? I have a VB6 application running on 70 different server workstations around the world. 95% of the time, the application will run in about 10 minutes, but I have noticed that sometimes the application is running for as many...

Greetings, At this very moment my other PC is chewing up about 40% of the CPU every other second. This causes the mouse and applications to briefly freeze. I have opened "Process Explorer from Sysinternals" and it is showing that the culprit is "Hardware Interrupts" where one paint of screen...

Greetings, Running Win-XP-Pro w/all updates on HP-Xt958. Brief version is I would like to know how I can determine who/what is driving the high number of hardware interrupts that I am seeing. Is there a monitor or log that can be used. Longer version: Over a month ago I noticed when moving...

I would appreciate a simple piece of code (VB) to provide network bytes sent and received from Performance Counters on a workstation (or is there another place?) Have Win-2000 application using MS-Access database on server and depending on size of backend database, there are some very ugly...

I have recently taken over an application that is deployed in 70+ countries and that has a history of poor performance. The facts are: Access 2000; Win-2000; frontend sits on user workstation; backend resides on server; typically between 1 and 5 users; 60+ tables; transaction data tables...

Greetings, I have a query that takes about 28 seconds to run. If I open the query, run it, then save the query, it will run in less than 3 seconds. I have found a couple of postings that mention this method to improve performance, but would like to know if anyone knows if there is a way to...

Access 2000 I need to be able to determine which visible detail row a user clicks on -- regardless of the record number. I have a continuous form that will show 13 rows in the detail section at one time. If I scroll down so that record number 30 is the first detail row shown, how can I get my...

Greetings, We are developing applications in Access-2000 on Win-2000 workstations and using sourcesafe to manage the Access database. On several occasions we have noticed (stumbled across?) a change that has been "lost", and obviously are deeply concerned. Most recently: I modified a module...