index and lock errors

[timck]

Can you please help I have a problem accessing my data, i get the messages below when i try? Do i need to reindex the file and if so how do i go about this???? Or is there just a share fault on the file which is causing theses errors???


these two messages appear in a box headed NAMES.

'Index is out of date file:Z:\DBS\WOFFMEM\PDOXUSRS.LCK.FILE:
Z:\DBS\WOFFMEM\PARADOX.LCK.TABLE:wm2.'

There are two other messages there NAMES

'GENERAL PROTECTION FAULT IN MODULE NAMES.EXE AT OOOB:44AA'

and

'CANNOT PERFORM THIS OPERATION ON A CLOSED DATASET'

If I'm unable to clear these messages I might need to look at a database transfer onto something more user friendly.

 

[beanbrain]

Try using Tools | Utilities | Restructure on the offending table. First I would try using the "Pack Table" checkbox and then "Save."

If this does not work you can then using Tools | Utilities | Restructure and remove all the keys (marked by an astrisk in the Keys column) save the table and then reopen it and reassigning the keys.

If this does not work you can try Tools | Table Repair. Use the browse button to populate the "Select Table Name" field. Then use the "Verify" button at the bottom of the Table Repair dialog. This will tell you if the table should be rebuilt. If it does need rebuilding then click the "Rebuild" button. Paradox will save the old table as "Copy of tablename" and create a new repaired copy of the offending table.

Let us know if this works.

 

[Langley]

Also, be aware that after a rebuild any secondary passwords (if they existed) will need to be recreated.

Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[dcpking]

did you clear your problem ?

If not, what OS are you usiong to get filenames

Z:\DBS\WOFFMEM\PDOXUSRS.LCK.FILE:
Z:\DBS\WOFFMEM\PARADOX.LCK.TABLE:wm2

?

Z:\DBS\WOFFMEM\PDOXUSRS.LCK
Z:\DBS\WOFFMEM\PARADOX.LCK

should be what you have. Normally, you should get all users to log off, delete all pdox*.lck files on Z:, and resetart using just one copy of Paradox to check things out. If you still get an "index out of date" error, then you'll have to rebuild or repair a table - not a particularly frightening task.

hth

Mike

 

[timck]

thankyou guys we will be looking at this over the weekend and i will get back to you as soon as possible with the result.

tim

 

[footpad]

timck,

Based on the "closed dataset" error, it sounds like you're using something other than Paradox for Windows to develop your application. I'm guessing you're using one of Borland's development tools, such as Delphi, C++ Builder, JBuilder, and so on.

If this is the case, then you'll also want to make certain your application properly sets the PRIVATEDIR and NETFILEDIR properties of your BDE Session object. Do this before opening any datasets in your application.

PRIVATEDIR needs to be set to a unique directory for each user (typically %TEMP%).

NETFILEDIR needs to be set to the same value for all users. This needs to a directory that all users can access with full read/write privledges.

I mention this because I've seen similar errors appear when there are different NETFILEDIR values in use.

As far as creating an index goes, you can do this with the IndexFieldNames property of your TBDEDataSet object. For more details, please refer to the Help file proivided with your development tool.

Hope this helps...

-- Lance