Link to home
Start Free TrialLog in
Avatar of TechGuise9
TechGuise9

asked on

Database built in Access 2007, won't open in 2010

I have a database that I built in Access 2007.   When opened in 2010, it appears to open ok, (goes to mainmenu), but all forms except one will not open.  Shows in Taskmgr to be running, but for all practical appearances it is locked up.  

One more bit of information.    I just figured out that all of the forms that didn't open (they seemed to lock the program up) had the POPUP and MODAL properties set to YES.    

These are also set this way in the 2007 version and it works.  Can anyone point me to why this isn't working in 2010?
Avatar of TechGuise9
TechGuise9

ASKER

I've tried moving the MSACC.OLB file from 2007 to the 2010 install, but that didn't work.   I've also added the folder as a TRUSTED LOCATION.
ASKER CERTIFIED SOLUTION
Avatar of Francis Omoruto
Francis Omoruto
Flag of Uganda image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
<I've tried moving the MSACC.OLB file from 2007 to the 2010 install, but that didn't work.  >
Why?
Make sure you return your system to it's original state...

To be sure Open the dB in Access 2007 and run the compact/repair utility.
Then create a new blank, Access 2007 format db and import all the objects.
Then open this new DB in access 2010 and see what happens.
Do you have any activeX controls on the form that's not opening?
No Active X controls.   Havent had ability to try importing all objects as boag2000 sugested.  Hopefull will try tomorrow.

Didnt' quite understand first post from fomoruto, read seemed pretty general.   Thanks all for imput.
Update...
Tried importing all objects into new database.   Pretty much same results
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That is what it was.   For some reason 2010 was handling multiple monitors differently, and the forms were simply opening off screen.  


Thanks!!
You're welcome!