Access 2003 mde file being opened in 2007

[Bunky]

We have several input forms that have VB coding on them. When the user goes
to these forms, the VB code is not working. We have enabled macros and tried
other approaches but todate, the VB code is not firing. Background. - I
created the database in 2003 and we are using a SQL server for the data.
When I make updates, I create a new mde file and copy it from our Staging
Lib. to Production. Now some of the users have updated to Office 2007
(without letting us know of course) and now the code on the forms is not
working. Still works fine in 2003. Short of a re-write, what can be done?

Thanks for your assistance in advance!

 

[Scott McDaniel]

We have several input forms that have VB coding on them. When the user goes
to these forms, the VB code is not working. We have enabled macros and tried
other approaches but todate, the VB code is not firing. Background. - I
created the database in 2003 and we are using a SQL server for the data.
When I make updates, I create a new mde file and copy it from our Staging
Lib. to Production. Now some of the users have updated to Office 2007
(without letting us know of course) and now the code on the forms is not
working. Still works fine in 2003. Short of a re-write, what can be done?

Thanks for your assistance in advance!

You need to make sure that your 2007 users have added the location of that .mde file to the Trusted Locations in Access
2007. Check this link for more info:

http://office.microsoft.com/en-us/access/HA100319991033.aspx

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com