How do I get VBA working in Access 2007 after converting?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin - 23 Jul 2007 19:38 GMT

I've converted a database built with Access 2003 to Access 2007. None of the
VBA functions work anymore even though they still exist in the property sheet
under Events. What's the deal here?

Reply to this Message

Allen Browne - 24 Jul 2007 03:49 GMT

The folder where your database is need to be added to the trusted locations
in Access 2007. Otherwise it won't run the code.

Go to:
Office Button | Access Options | Trust Center | Trust Center Settings

You might find this helps you avoid some other issues also:
Converting to Access 2007
at:
http://allenbrowne.com/Access2007.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I've converted a database built with Access 2003 to Access 2007. None of
> the
> VBA functions work anymore even though they still exist in the property
> sheet
> under Events. What's the deal here?

Reply to this Message