Search results for query: *

Sorry about the confusion. The application I'm referring to is an EXE built in VFP 9 SP2. And I'm convinced it's this application that is locking the file since exiting the application immediately releases the lock. I have been completely unsuccessful at reproducing the behavior on a...

Thanks Griff will give this a try. Olaf - I'm not that familiar with Procmon - should we be running that on the server or the workstation? And if it's not VFP causing the locking then wouldn't the locking persist even if the user exited VFP? In our case, as soon as the user exits VFP the...

Hey Olaf, Thank you for the response. I Realize that the computer management console does not refresh automatically. I will get a call from a user, then refresh the screen, see who the offending user is, have them exit the application and then all is fine. I just can't figure out how and when...

I have had numerous problems with an application that appears to be locking, and not unlocking a table. When I run COMPMGMT.MSC on the Windows 2008 R2 Server SP1 running as a virtual machine that is serving up this file. I go to Shared Folders -> Open Files and there is a column there that...

I am using VFP 9 SP2 on a PC running Windows 7 64 bit. It's running on an i5 CPU with 4GB or RAM. I have noticed that VFP runs very slow while most applications fly. Does anyone know of any special "tweaks" for Win 7?

I guess that make sense. However, when there is no find on that right table, I lose the table on the left thus destroying the entire query. I am not an experiened SQL programmer and could not find any other way, other than a Left Outer Join, to be sure that the entire query didn't fail becuase...

I am using Crystal version 8.5. I did not use smart linking and I made sure in the database expert that all joins were setup as left joins. Given the example that I'm showing here, I don't think you could even set this up in the expert. I made these changes directly in the Show SQL Query. I...

I have an interesting problem with the following SQL query used in a Crystal Report. The problem that I'm having is that even though I am putting in this specific SQL statement when the report is run from within SalesLogix the select statement is being adjusted. The problem is that some of the...