All good options except MSDE. That has a 2GB limit in TOTAL!

cheers

>Some options:
>

Pack the table if there are many deleted records
>

Reduce the length of the fields if you can
>

Split the table horizontally (TableA contains Field1 to FieldN, TableB contains FieldN+1 to FieldX)
>

Split the table vertically (TableA contains records 1 to N, TableB contains records N+1 to X)
>

Move to SQL Server/MSDE/etc.
>
>Good luck
>
>>how do i fix a 2gb table???