Ms Access Conversion to 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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"
 
Would you tell me step-by-step what to do, I am not sure how to check the
references. Thanks for your response.
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
 
Thanks Allen, that did it.
Fons

Allen Browne said:
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
Click to expand...
 
Back
Top