Functions worked in Access 2003 but not in Access 2007

[Tom C]

My functions worked in Access 2000 and 2003, but dont work in Access 2007.
Any tricks to this?

 

[Jeff Boyce]

Tom

Did you?:

* successfully compile the Access 2000 (and 2003) applications before
trying them in Access 2007?
* confirm that all references are set in Access 2007 (and not showing as
MISSING)?

You don't mention whether the functions that aren't working are actually
Access' (like "Date()" or "Sum()"), or are truly "your" functions? If they
are yours (i.e., home-grown), what are they (?all of them?!) trying to do?

More info, please!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tom C]

The functions are "homgrown". They do such things as analze text and convert
it into all capitals to match other portions of reports using multiple
databases. One uses a month number and assigns an abreviated month name, and
one cleans up data by removing commas, etc so that the data can be imported
into other databases.

I think I found the answer to my problem. I did need to recompile my
functions and had to change the security level to "enable all macros". Is
there a way to enable my macros without openning "Pandora's Box" like this?

 

[Jeff Boyce]

If you are working in Access 2007, the new security (thanks, Microsoft...)
can use either trusted locations or "signed" code.

What I've done for my day-job customers is set a folder up on their hard
drives that only I put things in, then trusted that location (and
sub-folders) from my Access 2007 applications.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tom C]

Thanks Jeff,
You've been most helpful.
Tom

If you are working in Access 2007, the new security (thanks, Microsoft...)
can use either trusted locations or "signed" code.

What I've done for my day-job customers is set a folder up on their hard
drives that only I put things in, then trusted that location (and
sub-folders) from my Access 2007 applications.

Regards

Jeff Boyce
Microsoft Office/Access MVP