Can I Add A Description to Fields in an Access Table Linked To SQL Server Via ODBC
Posted on 2015-01-16
I have numerous databases that are built on tables that are linked to our MRP SQL server. I am documenting these databases and would like to add a description to the fields of these tables but am concerned it will somehow affect the SQL backend. I understand I cannot modify the Fields or Data Types... I just want to add a Description. I tried one field with TEST and it saved even though it barked a bit (cannot remember what the notice was).
Bottom line: Will this cause problems with the SQL data?