CODEWITHSUNDEEP
databasems-accessoracle11g
Jonathan
Jonathan

Reputation: 164

Linked Oracle View not refreshing in MS Access Database

I'm facing an issue when refreshing linked oracle views in MS Access. I have a linked oracle view in an Access Database. I recently updated the oracle view at the backend to include new fields. Now, I tried refreshing the linked oracle view in the MS Access Database file using the 'Linked Table Manager'. But I still see only the old view structure, and not the new structure with the updated new fields. I tried creating a new linked view pointing to the oracle view. The newly created linked view also has only the previous structure of the view and the newly included fields are not seen. I recreated the DNS ODBC file and tried too. Has anyone ever faced such a scenario? Does any cache or registry have to be cleared to truly refresh the linked oracle views? Kindly help me with this issue.

Update: I found something upon further analysis. I mirrored the oracle view into a test view and linked it to Access. I found that the fields were missing here too. Now, I reduced the number of fields in the view to about 20 fields, and repeated the process. This time, I was able to see the new fields. I suppose the new fields are not showing up due to a limitation in the number of fields. Is there a setting where I can increase the number of fields that are brought into Access from a linked table? My original Oracle view has about 538 fields.

Upvotes: 0

Views: 246

Answers (1)

ComputerVersteher
ComputerVersteher

Reputation: 2696

The maximum number of fields in a table (a view is linked as a table) is 255. See Access specifications.

Show your views sql, as this seems to be a database structure issue. Usually you don't need that amout of fields.

To work around, create views on the view, with max 255 fields to display them.

Upvotes: 2

Related Questions