Limit to 255 columns

[Avi Oren]

Hey,

I am trying to open a table where the number of columns is
greater than 255.

======================================================
Here is code:

Dim rec_ALE As Recordset
Dim wrkJet As Workspace
Dim db_ALE As Database

Set wrkJet = CreateWorkspace("", "admin", "",
dbUseJet)


Set db_ALE = wrkJet.OpenDatabase("", dbDriverNoPrompt,
False, _
"ODBC;DSN=FFFF;uid=;pwd=;database=XXX")

========================================================

Is there a way for Access to "see" more than 255 columns?

Thanks,

Avi Oren

 

[Joe Fallon]

Nope.
That is the limit.
You need to break it up somehow.
Try using 2 Views on the source and link to them.
Then you can write make-table queries and finish the analysis in Access.

Perhaps you only need a subset of all those fields anyway so a simplified
View should work.

 

[TC]

Whoever designed the table may need to read:

http://support.microsoft.com/support/kb/articles/Q100139.ASP

HTH,
TC