ACC2000: Properties Collection Returns Error for CurrentProject and CurrentData Objects
Symptoms
All object collections under the CurrentProject and CurrentData objects contain a Properties collection. However, when you try to refer to the Properties collection of any object in a collection under the CurrentProject or CurrentData object, you may receive the following error message:
Run-time error ‘2467′:
The expression you entered refers to an object that is closed or doesn’t exist.
Resolution
Although you cannot use the Properties collection to refer to properties of these objects, you can refer to the properties directly. For example, use:
Debug.Print CurrentData.AllTables(1).Name instead of:
Debug.Print CurrentData.AllTables(1).Properties(“Name”)