How to Access all fields in MSSQL 2005 tables with Access 2007?

[Amos Sobel]

I am trying to manipulate SAP B1 MSSQL2005 data with Access 2007. I did find
that SAP B1 is using more than 255 fields on MSSQL2005 tables which are
inaccesible by Access 2007.
Is there a way to bypass this problem and access all MSSQL2005 table fields
from Access 2007?

Your help is very wellcome
Amos

 

[David H]

Not at one time. The maximum number of fields is 255.
http://office.microsoft.com/en-us/access/HP051868081033.aspx

 

[David H]

....and that being said, what exactly are you trying to do? While working with
over 255 fields isn't outside the realm of possibility, I find it highly
unlikely that you would actually NEED to work all the fields at one time.

 

[Amos Sobel]

Dear David

Thank you for coming back.

In the case I am working on, I need to access 20 fields out of 280 fields in
the Mssql Table. Some of the fields are higher than 255 so I can't access
them with the current Access2007.

Amos Sobel

 

[Amos Sobel]

Dear David

You did talk me to the very simple solution:

I have to create a MSSQL2005 VIEW which will pass the 20 relevant fields
into Access2007!

Thank You!

Amos Sobel

 

[David H]

Just explicitly select the fields you're working with as in...

SELECT FirstName, LastName, City FROM myTable