Buttons developed in Access 2007

[gst]

I created a form using Access 2007. I imported an exel spreadsheet into a
table and created some queries based on the data in the table. On the form, I
created several buttons to run the queries using the 'On Click' property. I
saved the database as 2003. When I open the database using Access 2003 the
properties are blank and there is no event associated with any of the
buttons. The pictures that I have associated with the buttons in the 2007
version do not appear in 2003.

Does anyone know why this happens and can I create a database in 2007, save
it as a 2003 format and not lose the functionality?

 

[Steve Schapel]

Gst,

... can I create a database in 2007, save
it as a 2003 format and not lose the functionality?

This would not be advisable. You should always develop in the lowest
version that the application will be used. It is too easy to
incorporate functionality that is new to the later version, which
obviously will then fail in the earlier version. In your specific
example, I suspect you have Embedded Macros assigned to your command
buttons, and this functionality is not supported in versions earlier
that Access 2007.