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