Using bit mask fields with hexadecimal in MS Access

davidgaven · October 21st, 2010, 10:05 PM

Boyd,

My problem today.........just when I solve one problem another is created. I think I might go straight to SSRS and give MS Access a miss.

Deep breath..

I have created a pass through query, used a DNS less connection string, works great - except for only accessing 151 columns in the table and not the full 168.

To test this is used this as my pass through query

Code:

SELECT SO.NAME AS "Table Name", SC.NAME AS "Column Name", SM.TEXT AS "Default Value" 
FROM dbo.sysobjects SO INNER JOIN dbo.syscolumns SC ON SO.id = SC.id 
LEFT JOIN dbo.syscomments SM ON SC.cdefault = SM.id  
WHERE SO.xtype = 'U'  and SO.name = 'Chart5'
ORDER BY SO.[name], SC.colid

And only 151 rows came back.

Why is this being restricted?

Do I need to create a view in MS SQL the source?

Thanks yet again.

David

Old Pedant · October 22nd, 2010, 04:05 PM

Pure guess: Because the other 17 columns are of a datatype that Access doesn't/can't support???

Find out what the data types are of the missing columns?

davidgaven · October 22nd, 2010, 04:49 PM

Sorry hold the phone........

I am looking at the old version of the database that has only 151 columns in this table. The new version has 168. So sorry. Brain fart, etc.

David

HiTechCoach · October 22nd, 2010, 04:56 PM

David,

Thank you for the update.

Glad to hear you have it sorted out.