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?
From what I remember up to Access 2010 no, a linked table cannot have its schema changed, to include a description.
Even if you can add that in Access, once the table is relinked that description would
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…