Hi,

I have an Access 2007 application, running under the runtime on Windows XP
clients (all sp's applied). Initially I got the 'Untrusted Source' warning
when starting the app, so I've added the install directory as a trusted
location on each machine and now this message no longer shows. Application
runs fine as an ACCDR file, but if I compile it to an ACCDE file, none of the
code in the application runs (so no command buttons work etc). there are no
macros; all code/functions are written in vba behind forms or modules as
appropriate. does anyone know how to succesfully run an ACCDE under the
runtime with code enabled? Am I missing something fundemental?

Thanks,

Jon.

[shambalad]

Jon -
If you wish to run an ACCDE file as a runtime on an XP machine that has only the runtime version of Access 2007 installed, you must rename the extension to ACCDR. You'll get a warning about renaming extensions, but, in this case, it's OK.
I recently completed a project where I created an ACCDE application in Access 2007 and implemented it on XP machines along with the runtime version of Access 2007. Basically, I created the ACCDE, then changed the trailing 'E' to an 'R'.