Template 'xxx.accdt' could not be instantiated.
An unexpected error occurred when opening the template.
Cause:
The XML encoding of the "&" symbol when used in the name of a database object like a table, query, form, report, macro or module.
Reproduce The Error:
Name a database objects (form, report, etc.) with an '&' in the object name.
Create a template (accdt) from the database.
Double-click the saved accdt file.
The instantiation will fail when it tries to create the object.
Workaround:
Avoid using the & in any database object name.
Comments:
It doesn't appear to be an issue when an '&' is used in a control within those database objects. It also does not seem to effect the original database or creation of the template, just instantiating a new database from the template.
Yet another good reason NOT to use non-standard characters in your object names.
3 comments:
Interesting... As every template I try and download from the Office site gives me this error... DAng!
That's good to know....I was just reading about how you should save your database like this so that people can read it without changing things. I wouldn't have thought to look for the & symbol. So now at least if I ever run into that situation I know what to check.
Huge help - thanks so much!!!
Post a Comment