• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

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?
0
gcgcit
Asked:
gcgcit
  • 4
  • 3
  • 2
  • +1
3 Solutions
 
Rey Obrero (Capricorn1)Commented:
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Do this first:

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

** Missing <SomeReferenceName>

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Rey Obrero (Capricorn1)Commented:
<it displays the data but my command buttons do not fire events etc.>

look at Security Changes in the first link posted above
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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
 
gcgcitAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
To start with, create a Trusted Location(s) ... and be sure your db(s) are in the Trusted Location(s).

mx
0
 
gcgcitAuthor Commented:
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
 
gcgcitAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now