Automation object in office template

[cathyt]

I’m not sure which area to post this in. Anyway, I’m trying to use an Access
2007 template (nutrition) I found on MicroSoft’s site, but in 2003. I
downloaded it on a co-workers computer, saved it for 2003 and opened it on my
computer. Right off the bat I get a “The object doesn’t contain the
Automation object ‘IsTrusted’†message. I have no idea what this means and
how can I fix it or get rid of it. Any ideas? Thank you!

 

[Arvin Meyer [MVP]]

If the database format is accdb, you will have to cobvert it to an mdb using
Access 2007, before you can use it in Access 2003. The accdb format is not
backwards compatible.

 

[cathyt]

Arvin, thanks for the reply. I did convert the database using 2007 following
instructions I found from Allen Browne on a different post. Maybe I should
try again... Thanks!

 

[Peter Hibbs]

I wouldn't bother. This database uses features ONLY found in Access
2007 such as embedded Macros (as far as I can see there is not a
single line of VBA code in the whole database). Since Access 2003 does
not support embedded Macros it is never going to work in this version.
You could convert it to 2003 and then add the VBA code to get it
working but this would be a mammoth task and not worth the effort.

Your only option is to use it in 2007 (perhaps you could use the free
Run-Time version of 2007).

Peter Hibbs.

 

[Arvin Meyer [MVP]]

I don't use templates (except for my own) so I hadn't thought about Peter's
reply. He is exactly right. One other thing. I've recently come across
problems with mdb's no longer working in Access 2003 if they had been
compacted in Access 2007, which almost assuredly happened at some point. See
if you can find a version in the 2003 template list.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access