🚀 go-pugleaf

Anyone, any ideas on:
HOW TO HANDLE/DISPLAY TABLES WITH HUGE NUMBER OF COLUMNS OR DATABASE FIELDS (eg., 4000+)-- WHEN USING ACCESS TABLES WITH ADO.
Access tables or Microsoft JET Engine, LIMITS according to Microsoft Specifications, the MAX # of Columns/Fields to 255/256.
WHAT is the solution to handle tables, for example with 4000 cols. which is way way above the specs.
***THE application needs to provide a read/write data aware DB Grid control, to the user, interfacing such a Access table(or any other database format) thru' ADO.***to read and modify data.
I am using TDBGrid, TDataSource, TADOConnection, TADODataSet, TADOTable, etc. etc.
One solution I see is to use a general purpose TStringGrid type of grid control, which probably can display 4000+ data columns...
COULD ANOTHER SOLUTION BE: to use multiple Table (inner) joins (like nearly 16 tables for 250x16=4000 total columns) going thru' a TADODataSet?  But TADODataSet again may be limited to 255/256 Cols. due to type of DataSource/DataConnection being Access table/JET Engine...
The application spec. calls for upto 4000 data columns, and unlimited number of records.
WHAT IS THE BEST SOLUTION HERE?  STAY AWAY FROM ACCESS TABLE FORMAT OR MS JET ENGINE OR ADO OR WHAT'S THE ALTERNATIVE DATABASE FORMAT AND INTERFACE TO USE?
==
THANKS A LOT & look forward to ideas/replies.
BASCAR  (BEE_M31@FASTMAIL.US)
----------------------------------------------