Solved

Converting 2003 to 2010

Posted on 2011-03-15
11
345 Views
Last Modified: 2012-08-14
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?
0
Comment
Question by:gcgcit
  • 4
  • 3
  • 2
  • +1
11 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 167 total points
Comment Utility
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 166 total points
Comment Utility
Do this first:

Open the VBA Editor >> Tools >> References ... and see if any are listed as:

** Missing <SomeReferenceName>

mx
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
<it displays the data but my command buttons do not fire events etc.>

look at Security Changes in the first link posted above
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 167 total points
Comment Utility
Sounds like the VBA is not enabled. Make sure that you trust the document  or set up a trusted location.

See my article here:
Trust Center in Access 2007 and 2010 Trusted Locations
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 21
Comment Utility
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.
0
 

Author Comment

by:gcgcit
Comment Utility
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
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
To start with, create a Trusted Location(s) ... and be sure your db(s) are in the Trusted Location(s).

mx
0
 

Author Comment

by:gcgcit
Comment Utility
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?
0
 

Author Closing Comment

by:gcgcit
Comment Utility
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.
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
"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
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now