gcgcit
asked on
Converting 2003 to 2010
I opened a 2003 database in 2010 and the interface looks great, it displays the data but my command buttons do not fire events etc.
Can an expert provide me with the appropriate resource (links and advice) to convert an Access 2003 database to an Access 2010 database?
Can an expert provide me with the appropriate resource (links and advice) to convert an Access 2003 database to an Access 2010 database?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<it displays the data but my command buttons do not fire events etc.>
look at Security Changes in the first link posted above
look at Security Changes in the first link posted above
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have Access 2003 MDEs that run under 2007 SP2 and 2010 just fine without any modifications. . The key was enabling the VBA by creating a trusted location.
ASKER
I've found the Trust Center but am unsure which settings need to change in order for my VBA code to fire.
These are the menus I see in the Trust Center: Please advise:
Trusted Publishers
Trusted Locations
Trusted Documents
Add-ins
ActiveX Settings
Macro Settings
DEP Settings
Message Bar
Privacy Options
These are the menus I see in the Trust Center: Please advise:
Trusted Publishers
Trusted Locations
Trusted Documents
Add-ins
ActiveX Settings
Macro Settings
DEP Settings
Message Bar
Privacy Options
To start with, create a Trusted Location(s) ... and be sure your db(s) are in the Trusted Location(s).
mx
mx
ASKER
I created a Trusted Locations and now I'm getting an error that I'm missing the reference to utility.mda
I look in references and it's path is: c:\program files\microsoft office\office 11\utility.mda
where could I find one that works with Version 2010?
I look in references and it's path is: c:\program files\microsoft office\office 11\utility.mda
where could I find one that works with Version 2010?
ASKER
All three of you provided solutions to the answer, it was a trust center issue and references missing. I hope you agree with splitting the points. Thank you for the reference links - very helpful.
"I'm getting an error that I'm missing the reference to utility.mda"
Just remove that Reference. Highly unlikely you need it. This seems to be a common missing reference.
mx
Just remove that Reference. Highly unlikely you need it. This seems to be a common missing reference.
mx
Access 2010 Migration Guide:
http://blogs.msdn.com/b/access/archive/2010/09/07/download-the-free-access-2010-migration-guide.aspx
Access 2010 Resources:
http://technet.microsoft.com/en-us/office/gg406142.aspx
Access 2010 Object Model Changes Since Earlier Versions
http://msdn.microsoft.com/en-us/library/ee836189%28office.14%29.aspx
mx