Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Index problems
- Thread starter adale
- Start date
TonyMcGuire
Programmer
What size are the tables?
What BLOCK size are the tables?
Do you have oplocks turned off?
How about write cache on the HD the data resides on? (The OS doesn't always allow this.)
Tony McGuire
"It's not about having enough time. It's about priorities.
What BLOCK size are the tables?
Do you have oplocks turned off?
How about write cache on the HD the data resides on? (The OS doesn't always allow this.)
Tony McGuire
"It's not about having enough time. It's about priorities.
- Thread starter
- #3
TonyMcGuire
Programmer
OK. Sizewise you aren't even close, even with 2k block.
I'd check opLocks settings.
As well, make sure all machines have Local Share = True in the BDE.
Is this a shared data environment?
If so, what OS is the server? And is the server dedicated, or a workstation as well?
Tony McGuire
"It's not about having enough time. It's about priorities.
I'd check opLocks settings.
As well, make sure all machines have Local Share = True in the BDE.
Is this a shared data environment?
If so, what OS is the server? And is the server dedicated, or a workstation as well?
Tony McGuire
"It's not about having enough time. It's about priorities.
- Thread starter
- #5
The whole thing runs on a desktop PC with WinXP.
I'bve just found out that it's 2 service packs out of date so am updating that first.
The user either runs a VB app to populate the database, or goes into Paradox itself and uses forms & reports.
Normally they would use each method exclusively, but recently they may be opening both at the same time which makes me think of write conflicts.
Where does opLocks reside?
I'bve just found out that it's 2 service packs out of date so am updating that first.
The user either runs a VB app to populate the database, or goes into Paradox itself and uses forms & reports.
Normally they would use each method exclusively, but recently they may be opening both at the same time which makes me think of write conflicts.
Where does opLocks reside?
TonyMcGuire
Programmer
opLocks is a setting (or 2, depending on OS and what the machine is doing (server, server/workstation) in the registry.
Copied article at with a link to the actual M$ article.
VB? Well, I'd certainly go to that code and ensure things are being done properly. And that a correct ODBC driver is being used; some versions from M$ don't support proper editing, and some don't support editing beyond Table Level 5.
Tony McGuire
"It's not about having enough time. It's about priorities.
Copied article at with a link to the actual M$ article.
VB? Well, I'd certainly go to that code and ensure things are being done properly. And that a correct ODBC driver is being used; some versions from M$ don't support proper editing, and some don't support editing beyond Table Level 5.
Tony McGuire
"It's not about having enough time. It's about priorities.
- Thread starter
- #7
I think I've found what part of the problem is now.
The production files are moved to a reporting server and in that process one of the .val files wasn't getting updated. I totally refreshed the report server copy of the files and am not getting the error so much now.
I've also stopped the vb app and Paradox db being used at the same time.
Re the ODBC driver, we use Paradox's as Microsofts doesn't support any sort of sharing.
Thanks for your help.
The production files are moved to a reporting server and in that process one of the .val files wasn't getting updated. I totally refreshed the report server copy of the files and am not getting the error so much now.
I've also stopped the vb app and Paradox db being used at the same time.
Re the ODBC driver, we use Paradox's as Microsofts doesn't support any sort of sharing.
Thanks for your help.
TonyMcGuire
Programmer
"...am not getting the error so much now."
Does this mean you fixed the error, or you are still getting it 'sometimes'?
Tony McGuire
"It's not about having enough time. It's about priorities.
Does this mean you fixed the error, or you are still getting it 'sometimes'?
Tony McGuire
"It's not about having enough time. It's about priorities.
- Thread starter
- #9
As luck would have it, I did get the error again after I wrote that email.
Then I found some further email therads that said the .val file related to the bad tables can sometimes get confused.
They can be deleted and will get recreated by the database automatcally. Since I deleted those .val files I haven't had any more issues.......so far.
Then I found some further email therads that said the .val file related to the bad tables can sometimes get confused.
They can be deleted and will get recreated by the database automatcally. Since I deleted those .val files I haven't had any more issues.......so far.
SundialServices
Programmer
(1) Make sure that all indexes are marked "maintained." If not they immediately are considered "out of date."
(2) Make sure that all tables related to this one have the same "table language." If, for example, table-X is French and table-Y is US_ASCII, you'll always have problems.
(2) Make sure that all tables related to this one have the same "table language." If, for example, table-X is French and table-Y is US_ASCII, you'll always have problems.
- Status
