Ms Access Conversion to 2007

[Guest]

I have several MDB files created in 2003 (XP) that ran fine. After upgrade
to MS Office Enterprise 2007 these data bases no longer function. I did use
the ConTool.msi without any comments. I also did save the mdb to the new
2007 file. When I start the data abse after conversion the screen opens as
usual on the first form I created as a menu but clicking on any of the
buttons does not produce any results as if the code behind the buttons is not
recognized.
Any Adve? Thanks for any input.

 

[Guest]

Check the references to see if any are not found.
You may need to register some libraries. I've run into this answered a few
times on this website. Following are copies from these. I'm not sure if they
are the same for 2007.
Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"
Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

Note: You'll need to first verify that the paths shown above are correct.

Regsvr32 "C:\Program Files\Microsoft Office\office11\Accwiz.dll"
Regsvr32 "C:\Program Files\Common Files\System\ADO\msadox.dll"

 

[Guest]

Would you tell me step-by-step what to do, I am not sure how to check the
references. Thanks for your response.
Fons

 

[Allen Browne]

The code will not run unless the database is signed or in a trusted
location.

Click the Office Button | Access Options | Trust Center | Trust Center
Settings.
Then add your folder to the trusted locations.

That should get it going.
If you want to check references, press Ctrl+G to open the Immediate Window,
and choose References on the Tools menu. For a list if the references you
should have for each version of Access, see:
http://allenbrowne.com/ser-38.html

 

[Guest]

Thanks Allen, that did it.
Fons

The code will not run unless the database is signed or in a trusted
location.

Click the Office Button | Access Options | Trust Center | Trust Center
Settings.
Then add your folder to the trusted locations.

That should get it going.
If you want to check references, press Ctrl+G to open the Immediate Window,
and choose References on the Tools menu. For a list if the references you
should have for each version of Access, see:
http://allenbrowne.com/ser-38.html