>I have a table that the dbf is just over 1 meg but the fpt file is rapidly approaching 2 gigs and I wondered if the 2 gig limit applies the that file as well. In case it matters workstations are windows 98 but file resides on server which is windows 2000. Thanx for any help.
>
>Walt
Both.
You can consider client/server, but there also are several other things you could do first, for instance:
Pack will reclaim wasted space.
Keep pictures out of the database - just save them as JPG files, and have the filename in a character or short memo field.
Split your table horizontally or vertically.
Proper normalization often saves some space, and makes individual tables smaller.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)