Thanks for the suggestions but I can't find those options. We are using the 2003 version and when I go to Tools>Macros> I don't have a security option. My only options are visual basics editor, microsoft script editor, run macro, convert macro to visual basics, create menu from macro, create toolbar from macro, creat shortcut menu from macro.
We are a small company and I created the database that only 2-3 people use so I don't mind setting the security to low, but I just can't seem to find where to do that??