Since then, I have made significant changes to the original code to address all the above issues and further extend its functionality. These tables caused error 3959 - Calculated columns are not allowed in SELECT INTO statements.ĭ) Table names with spaces or special characters caused error 3067.Īs a result, the original code received a rather mixed reception from some forum members. These tables caused error 3838 - Multi-valued fields are not allowed in SELECT INTO statements.Ĭ) Tables with calculated fields could not be handled. The original code by vkl worked for many local and linked tables but had several important drawbacks:ī) Tables with complex fields (multivalued, attachment and column history memo fields) could not be handled. The table data is saved after which the temporary database is deleted as it is no longer needed. The utility calculates the approximate size (disk space occupied) of all tables by exporting them to a temporary database and comparing the database size before and after export. You can also determine the size of each table (disk space occupied), view its data and the table design.Īll field types can be handled including calculated and complex fields (attachment, multivalued and long text column history) Select a database and a list of its tables (local / linked / system) are shown.įor encrypted databases, you will be prompted to enter the password.įor each table, the table type, number of fields and records are displayed. It can, for example, be very useful when taking over existing applications from clients where a detailed understanding of the structure and size of each table is an important first step. This utility allows you to quickly analyze the tables in any database without opening it directly. The original idea for this application was loosely based on a thread published at Access World Forums by member vkl in Aug 2019 : Table Size Analysis This is a significantly updated version of a utility designed to analyze tables in external databases. Section Links: Introduction Table Analyzer Table Viewer Downloads Purchase Source Code Video Feedback Version 2.32 Approx 0.86 MB (zipped) First Published Last Updated
0 Comments
Leave a Reply. |