Forum Discussion
Getting column widths from MSysObjects using SQL
Hi All, I work with an application that allows me to run SQL on the database to which it is connected. I want to be able to get column widths for tables like I can using the system table USER_TAB...
Hi Tieme,
Thank you very much for the VBA code, I will keep that under my hat.
What I am really looking for is a method that will work with an ACCESS database 'out of the box' because I cannot necessarily expect my target audience to change their databases by adding functions. I really don't understand why column data in MSysObjects is not SQL-minable.
Thank you again.
You won't find anything native. Such customization nearly always require VBA. Access is highly versatile but usually this is fine through advanced coding.
What is the end game here? What are you trying to achieve exactly? Maybe if we understand that better, we might be able to offer some suggestions?
What is the end game here? What are you trying to achieve exactly? Maybe if we understand that better, we might be able to offer some suggestions?