Search code examples
ms-accesscalculated-field

MS Access Calculated Field to test if Table exist

I have a list of names in my database that should have a corresponding Table named after it. I would like to have a check in the adjacent column that checks if the Table actually exists.

I could technically achieve this through code but was just wondering if a calculated field can achieve the same results.

ID  TableName   Exist   
1   Cat         TRUE    
2   Dog         TRUE    
3   MooMoo      FALSE   <---Table does not exist in db
Solution

  • You can't.

    You'll need a user defined function, UDF, to check for the table, while only native functions can be used in the expression for a calculated field.