Submitting Access2007 template to Microsoft

[Mark Andrews]

I went to submit an Access2007 .accdt template file to Microsoft's site:
http://office.microsoft.com/en-us/templates/CT101172481033.aspx

and got this message:
Your template cannot be submitted, because of one of the following
problems: - The template either contains non-Access active content, such as
macros, embedded objects, linked images, or ActiveX controls. - The template
has a bad title, display name, category, or description. - The template is
missing an Access preview image (JPG, GIF, PNG, or BMP). - The template is
not for one of the following 2007 Microsoft Office system programs: Access
2007, Excel 2007, PowerPoint 2007, Publisher 2007, or Word 2007. Check the
template you want to submit, and then submit it again.

Does anyone know the restrictions for posting templates?
For example this simple template has:
- a small amount of code
- one regular macro
- some embedded macros
- some embedded pictures
- has a preview image
- hopefully has valid title, display name, category and description?

Thanks in advance for your help,
Mark

 

[Douglas J. Steele]

AFAIK, templates will not be accepted if they have any VBA in them. From the
message you posted, it also looks as though you may not be able to include
regular macros either.

 

[Mark Andrews]

My guess was VBA was the issue, I'll try removing the VBA code as step 1,
and if that doesn't work I'll also remove the stand alone macro.

I guess I saw both some code and macros in the default templates so wasn't
sure?

I kept most of the logic as embedded macros (for that very reason, I'm more
of a everything should be code kinda guy).
If they aren't allowed, then I guess I won't be submitting a template to
Microsoft
(because they don't allow any templates that could be useful).

If anyone else knows any more details please chime in!!!

Thanks for your help,
Mark