Access not reading extended parameters We have an ADP Access 2010 project, linked to a MS SQL 2012 server.

I am trying to set up a table that has a combo box to select appropriate values, which are supplied by another table.

A table under the default dbo schema reads the extended properties, and shows the appropriate combo box


When I try to add the same extended properties to a table that is under another schema, the combo box does not appear.

What do I need to do to solve for this, or am I resigned to giving up with the task, and deal with it later when we drop the ADP?

(I tried asking this on SuperUser, but got no response)

Access code that opens table that works:

Private Sub cmdAvayaQ_Click()
DoCmd.OpenTable "dbo.tbl_o_etc_Avaya_Skills", acViewNormal, acEdit
End Sub


Access code that opens table that doesn't work

Private Sub cmdNonPhone_Click()
DoCmd.OpenTable "forecasting.tbl_nonphone_queues", acViewNormal, acEdit
End Sub
I don't use Access, but it is likely that it is unable to query extended properties except those under the dbo schema - it must make the assumption that everything is under dbo. I don't really have a solution for you other than not using schemas with your ADP if extended properties are critical.