Switching from Access 2003 to 2007

[BZeyger]

Hello,

I currently have a VBA Module that I use to keep track of projects. It was
created in Access VBA 2003. Will have any issues once I convert to 2007? I
want to make sure my queries, forms, and reports will still function.

Thanks

 

[Jeff Hunt]

I can't say definitively, but I have had several projects from Access 2000
and Access 2003 that I have successfully used in Access 2007. You will need
to make sure that all your references stay the same (VBA window, Tools,
References...) but those should remain with the database, not the program
itself. You will find that every time you open the database Access warns you
that the code is being disabled for safety. You can enable it each time, or
you can just set the folder containing your database to be in your trusted
zone.

To trust your folder, click:
Office Button (top left)
Access Options (bottom of dialog)
Trust Center (left)
Trust Center Settings (button)
Trusted Locations (left)
Add new location (button)

HTH.
....jeff...