Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

table index problems

table index problems

table index problems

We've been using paradox since 1994. We've had a few problems along the way, network speeds, particular station settings etc. This one is different. The largest table is almost a million records. It has 9 fields, block size 4, record size 48. It has one secondary index and currently no other lookups (I've removed them to eliminate issues) Several times over the last week I've repaired the table. I've done this a couple of different ways. Once just chimney sweep repair, once query and then reindex and once create a new table  borrowing the structure and then adding the records. I got a little scared and copied out an ascii file too, but haven't used it. All the records didn't add, but I worked around that with old table copies. I increased the block size to 16. (created the new table with block size 16) This seemed to cause trouble immediately. I went back to 4. I've got Paradox version 10 but the BDE is running on version 5. Is this normal? Do you have to use a higher level feature in order for the table to be a higher level? Is this the same as "file format" in the table repair utility? I don't use that, but look sometimes and verify. I do use terminal services, so the server is doubling as a workstation when I'm on it. It hasn't caused problems in the past. Questions are two fold...do all the tables involved in a form have to be exactly the same block size or file format or level? What is the formula for using table specs and determining where it falls in accordance with "paradox limitations".

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close