Last Updated: March 1, 2023
ISSUE
The Database.CreateTableDef method incorrectly stores the name of the remote table as the name of the local table in the TableDef Object, which may cause the call to TableDefs.Append to fail.
Users who encounter this issue will get an error like the following:
The specific problem is that the name specified for the source table in the CreateTableDef method is being used as the name for the local table being created. This is why linking to “Items”, for example, works but linking to “dbo.Items” does not, because the ‘.’ is not valid in a local table name.
This issue impacts Access 365, Access 2019 Consumer, and Access 2021 Consumer, Version 2212, Build 15928.20000, and subsequent builds.
STATUS: FIXED
This issue has been fixed in Version 2301 for all impacted Office SKUs.
More Resources
Ask the experts
Connect with experts, discuss the latest news, updates, and best practices, and read our blog.
Get help in the community
Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Office users.
Suggest a new feature
We love reading your suggestions and feedback! Share your thoughts. We're listening.