Limit to 255 columns

  • Thread starter Thread starter Avi Oren
  • Start date Start date
A

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
 
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.
 
Back
Top