Field Limitation??? (1 Viewer)

gmatriix · Oct 18, 2019

Hey Guys,

Ran into a problem I have not encountered before.

I am linked to a SQL db that have many tables.

One in particular has 403 fields....I am limited to see and use the first 255

any way around this??

Anyway to choose the fields I want....most of those fields I do not even use...

The fields I use is not even close to 255

It only shows me that amount and cuts off the rest...??:banghead:

plog · Oct 18, 2019

First the admonishment--a table with that many fields is not a properly structured table, someone didn't know what they were doing. If there is any way to fix that you should.

If you do not have the authority to do that, then I suggest creating a View within the SQL database. Bring in just the fields you need, create the View object in the SQL database and then link to that View from Access.

theDBguy · Oct 18, 2019

Hi. Unfortunately, Access tables are limited to 255 fields/columns and there's no way around that. I agree with plog and try to use a View in SS with just the necessary columns to link from Access.

gmatriix · Oct 18, 2019

plog said:
First the admonishment--a table with that many fields is not a properly structured table, someone didn't know what they were doing. If there is any way to fix that you should.

If you do not have the authority to do that, then I suggest creating a View within the SQL database. Bring in just the fields you need, create the View object in the SQL database and then link to that View from Access.

Agreed...

We are talking about old...since whenever databases.....

I just work here...in work around city because...problems have been past down from generation to generation...lol

I figured as much...but thought I give it a shot...

Thanks again guys!

theDBguy · Oct 18, 2019

gmatriix said:
Agreed...

We are talking about old...since whenever databases.....

I just work here...in work around city because...problems have been past down from generation to generation...lol

I figured as much...but thought I give it a shot...

Thanks again guys!

Hi. No sweat. We've all been there. No one was blaming you. Good luck!

Field Limitation??? (1 Viewer)

gmatriix

Registered User.

plog

Banishment Pending

theDBguy

I’m here to help

gmatriix

Registered User.

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread