128 reputation
6
bio website awmisfits.com
location Texas
age 46
visits member for 2 years, 3 months
seen 22 hours ago

Afterworld player, and forecasting/VBA/excel/access to support the habit :)


Sep
23
awarded  Scholar
Sep
23
accepted Access not reading extended parameters
Sep
23
awarded  Editor
Sep
23
comment Access not reading extended parameters
seems Access will only apply extended properties from the dbo schema - your comment lead me in the right direction. Add it as an answer, so I can accept it
Sep
23
revised Access not reading extended parameters
added access code
Sep
23
comment Access not reading extended parameters
The extended properties are for setting up a combo box dropdown for the column. It works fine within the dbo tables, but not within the other tables. When Access attempts to set the properties, it states I do not have permission, but I can add them from SSMS (I even had them added by the sa to see if that was the issue). I have a feeling it has something to do with the way access accesses the table, but as this is the only experience I have had with extended properties, I wanted to make sure I was doing nothing wrong server side
Sep
22
comment Access not reading extended parameters
The user is owner of the second schema. dbo is the users default schema
Sep
22
asked Access not reading extended parameters
Nov
13
awarded  Teacher
Jul
2
awarded  Supporter
Jul
5
awarded  Autobiographer
Jul
5
awarded  Analytical
Jul
5
answered How to transfer files at remote location using sql server job?