2003 to 2007

[Chazcoral]

I created a database on 2003, I used comand buttons which open form and duplicate entries. They worked well in 2003 but not 2007. I recreated the buttons in 2007 and they are still not working. What can I do to make them work? when I am using 2007

[pbaldy]

If no code is running at all, you either need to place the database in a trusted location (Office Button/Access Options/Trust Center) or explicitly enable code.

[Chazcoral]

Are you saying move the entire database? Are you saying that the folder needs to be called (Office Button/Access Options/Trust Center), or is that just an example?

[pbaldy]

The folder can be named anything. The path I gave you is where you tell Access where the safe locations are. By default, code will be disabled if the database isn't located in one. You should also be able to click on an option just below the ribbon, but you'll have to do it every time.

[Chazcoral]

I created the program on my computer which has 2003. I have a shared computer that my team uses to open the database from the same folder, but it has 2007. It works fine on my pc but not the shared pc. If I understand you, you are saying it is the location of the database not the version of software.

[pbaldy]

Correct; by default, Access 2007 will disable code to protect you from yourself. Go into that location on the PC with 2007 and add the location of the database in Trusted Locations.

[Chazcoral]

That worked. Thank you very much for your help.

[pbaldy]

Happy to help; glad it worked for you.