Advantage Database Server works well with VFP.
http://www.extendedsystems.com/ADS/Product+Detail/Advantage+OLE+DB+Provider/default.htmYou might want to look into it. It's a lot cheaper than SQL Server.
Tracy
>Hi everyone,
>
>I never thought to see the day, but now it is happend. I have a client who is pushing through heaps of stuff. and now I am facing the 2GB problem. Aside from breaking up the tables (which is going to be a pain), or upsizing to SQL (not a near term solution), is there anything suggestions?
>
>Background: Currently in VFP6SP4. Issue is affection finance transaction table history file. They run a 'period close' (like a monthly statement) and the current period data gets shoved into the history. However, although we have been routinely re-routing the history table, the current period table is now rapidly approaching the 2GB barrier.
>
>TIA
>
>Ric
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
