Linked tables having Calculated field can’t be made Local in MS Access 2016

Background:

For the purpose of taking backup of the MS access database, VBA script failed for one of the tables of the source database, showing “Property not found Error: 3270“.

Resolution:

Compact and repairing didn’t solve the issue, recreated the table also didn’t help. Upon further dig down its been observed that removing the “Calculated” field from the table solves the issue.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.