Unanswered: linked access server metadata info does not match error
i have an access database as a linked server inside sql server 2005.
the query giving me an issue is the following:
select * from Openquery (OEA, 'Select * from header')
the error message is:
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' for linked server 'OEA' returned data that does not match expected data length for column '[Microsoft.Jet.OLEDB.4.0].City'. The (maximum) expected data length is 100, while the returned data length is 9.
i dont know how i can fix this.. i've read that it has to do with the metadata info not being in sync...
help would be awesome.
as a workaround, instead of doing a select * on the table header, im doing a select on just the fields that i need ( which does not include the field city) but thats a problem waiting to happen if i leave it like it is