 RE: Index out of Date
|
RE: Index out of Date in Paradox Setup, Vista, etc. topic (part of our Corel Paradox / ObjectPAL Coding group).
Quick Search:
RE Index
RE Index out
of Date
|
| |
|
|
| Moderator |
|
Steven.G
|
there was some kind of network "group" setting, after a generic win update, that suddenly was defaulted to "reconnect" constantly.. that was blowing out the concurrent table/index logic, which was blowing out the indexes
I'd have to ask my IT guy what it was, specifically
everything you list above, is correct.. this was a new windows "feature"
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
|
Posted 54 months ago (Thread Starter)
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18336, 7 replies
and Parent is 18334
Thread Started 1/8/2021 8:25:30 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
| |
|
|
| Moderator |
|
|
Steven.G
|
I left a message for my IT guy.. I'll let you know what he says
however, you're describing a very serious issue, not simply out-of-date indexes.. you've already checked that everyone is mapped to the net file and to the data using the exact same path, correct?
even if everyone is using RDP the same, the net file should be mapped to a drive letter, too, not C
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
|
Posted 54 months ago (Thread Starter)
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18341 (Level 2)
and Parent is 18334
Reply Posted 1/11/2021 10:04:27 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
| |
|
|
| Moderator |
|
|
Steven.G
|
I know it works fine, in theory, but I have this thing about using C drive natively.. even with local share = TRUE.. all of the internals are 20 to 30 years old, and you never really know what's going on in there
your mileage may vary :-)
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
|
Posted 54 months ago (Thread Starter)
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18344 (Level 3)
and Parent is 18334
Reply Posted 1/12/2021 10:52:22 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
| |
|
|
| Moderator |
|
|
Steven.G
|
did you rebuild and restruct EVERY table before you put them back, on the new system? my "old" comment above just reminded me that this could all be related to your "old" and the possibility that the index file names might have gotten scrambled.. long file name / short file name stuff, you were using server 2003, which goes way back, too
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
|
Posted 54 months ago (Thread Starter)
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18345 (Level 4)
and Parent is 18334
Reply Posted 1/12/2021 10:54:02 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
| |
|
|
| Moderator |
|
|
Steven.G
|
you're doing everything right, the way you're looking at the settings, the structures, etc
>The new tables worked perfectly for a single user but once several users started accessing the tables.... corruption ensued.<
and you've described real corruption, not just common table-and-index errors.. usually, that means two instances are using concurrently, but don't know that they are using the same files.. which usually means two net files and/or two drive letters
download remlock32.. run it and see if you've got multiple net files or lock files.. it'll take a few minutes to run, it's old :-)
http://www.oasistradingpost.com/cartpages/paradox.htm#Remlok32
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
|
Posted 54 months ago (Thread Starter)
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18350 (Level 5)
and Parent is 18334
Reply Posted 1/14/2021 7:55:13 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
| |
|
|
| Moderator |
|
|
Steven.G
|
no, this is something different.. each user has their own net file, and if they're coming and going in the data, they're each attacking it like they're the only one there
get everyone out.. let remlok32 kill all the net and lock files, so you start clean
go to the BDE, set your correct net file, make sure the cfg gets saved.. you can put a shared copy of the cfg some place else (i.e. with the net file), and point to both in your command file.. look at command-line options in the help
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
|
Posted 54 months ago (Thread Starter)
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18352 (Level 6)
and Parent is 18334
Reply Posted 1/14/2021 11:59:30 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
| |
|
|
| Moderator |
|
|
Steven.G
|
sounds like a simple thing to test.. and it should work
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
|
Posted 54 months ago (Thread Starter)
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18354 (Level 7)
and Parent is 18334
Reply Posted 1/15/2021 5:41:34 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
| |
Most Recent Post
|
|
| Moderator |
|
|
Steven.G
|
the Win7 UAC defaults, and how different settings affect other things, can be confusing
and yes, in general, I put cfg file and ini files in the folder with the net file, and point to them on the command line
good detective work !!
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
|
Posted 54 months ago (Thread Starter)
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18361 (Level 8)
and Parent is 18334
Reply Posted 1/16/2021 6:48:32 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
Revive Thread!
Add a comment to revive this old thread and make this archived thread more useful.
| Thread #18334 Counter |
| 0 |
|
Since 1/8/2021
|
|
|
|
Paradox
Print This