Table doesn't close, despite 'close database' command

[1421]

Hi All

The description of my problem tells all. I am having a problem with 1 DBF. I am developing an application and very often I need to open this DBF exclusively. Quite often Foxpro doesnt let me open it exclusively. Issueing a 'close database' command doesnt help. After a while it is again available exclusively. I imagine the server may have been rebooted & therefore it was 'released'. What can cause this to happen? The strange thing is that its only happening to 1 dbf. It is a large DBF (684 bytes).


Thank You

the following display's the structure
===========================================================
Code Page: 1252
Field Field Name Type Width Dec Index Collate Nulls Next Step
1 ACCOUNT Numeric 10 No
2 CASE_NUM Numeric 6 No
3 TIMESTAMP DateTime 8 No
4 CLIENT Numeric 6 No
5 CARRIER Numeric 6 No
6 PROVIDER_G Character 10 No
7 GROUP Character 2 No
8 H1_NAME Character 25 No
9 H1_NUM Numeric 6 No
10 H1_HOSP Numeric 6 No
11 H2_STREET Character 25 No
12 H2_BATCH Character 3 No
13 H3_CSZ Character 30 No
14 B1_INS_TP Character 8 No
15 B1A_INS_ID Character 20 No
16 B2_PAT_NAM Character 42 No
17 B3_DOB Date 8 No
18 B3_GENDER Character 1 No
19 B4_SUB_NAM Character 35 No
20 B5_B7_STR Character 25 No
21 B5_B7_CITY Character 15 No
22 B5_B7_ST Character 2 No
23 B5_B7_ZIP Character 10 No
24 B5_B7_PHON Character 12 No
25 B6_PAT_REL Character 2 No
26 B12_31_DAT Date 8 No
27 B17_REF_NM Character 15 No
28 B17_REF_NU Numeric 10 No
29 B21_DIAG1 Character 10 No
30 B21_DIAG2 Character 10 No
31 B21_DIAG3 Character 10 No
32 B23_AUTH Character 20 No
33 B24_CTR Numeric 1 No
34 B24A_SDATE Date 8 No
35 B24B_INOUT Character 2 No
36 B24_STR_TM Character 7 No
37 B24_END_TM Character 7 No
38 B24_TOT_MN Numeric 6 No
39 B25_TAXID Character 9 No
40 B25_TAXIDT Character 1 No
41 B27_A_A Character 1 No
42 B28_B_ORIG Numeric 10 2 No
43 B30_B_CURR Numeric 10 2 No
44 B31_C_NAME Character 25 No
45 B31_C_LIC Character 6 No
46 B32_H_NAME Character 25 No
47 B32_H_STRT Character 25 No
48 B32_H_CSZ Character 30 No
49 B33_G_NAME Character 25 No
50 B33_C_STRT Character 25 No
51 B33_C_CSZ Character 25 No
52 B33_C_PHON Character 14 No
53 B33_GRP Character 15 No
** Total ** 684

 

[Mike Lewis]

There are a couple of things you can check (sorry if these are obvious):

1. Are you sure no other user has the table open?

2. Do you have an open project manager window that contains the table? Sometimes, when you close a table, the project manager will immediately re-open it, for example so that it can display its drill-down info.

3. Is the table open in another data session? Closing a table in one data session won't close it in another.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[1421]

Thanx Mike,

The answer to all of your questions are no. As I mentioned, this is a table that is in the development stage and as-far-as-i-can-see i am the only one working on it remotely using Terminal Server. I even reset my terminal server session(s) & even rebooted Terminal Server & it still did not help. My only clue is the large file size 684 bytes (?).

 

[JRB-Bldr]

When I encounter a situation like this I use a tool like WhoHasNt

http://www.gadgetfactory.com/whohasit.shtml

or Hyena

http://www.systemtools.com/hyena/index.html

or similar tools.

With it I can quickly determine who it is that the system thinks has the file open. In most cases I have quickly found the user and resolved the problem.

Good Luck,
JRB-Bldr

 

[DSummZZZ]

I have also used the whohasit utilities jrbldr mentioned and they work quite well for determining just what computer has the files opened.

If you're interested, you can also take a look at the VFP utility I wrote for listing open files. It's a freebie.
Go to the link in my signature and scroll down until you find the "Open File Lister" app.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm