Tag Archives: Table

No Thumbnail

Access Field Properties Locked

This articles explains the reason why the field properties of a table become locked and unmodifiable: – Why? The main reason, that the field properties get locked is because you have a form associated with the table open: Once the form is closed, the field

No Thumbnail

Access Create Link To Excel Sheet

This article explains how to create a link from Access to an Excel sheet. – What is it? A link to an excel sheet will allow access to get certain values from the excel workbook. When the values in the Excel workbook change, so will

No Thumbnail

VBA Access Get Table Names

In this article I will explain how you can get the names of all the tables in an access database using VBA. – Get Table Names: In the example below the names of the tables will be stored in a string array. The database used in

No Thumbnail

Check If Table Exists, Access VBA

In this article I will explain how you can check if a table exists in an access database using VBA. Previously in the article below I’ve explained how you can get the name of all the Tables in an external access database using VBA: VBA