Solved

Converting 2003 to 2010

Posted on 2011-03-15
11
350 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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 167 total points
ID: 35141272
0
 
LVL 75

Assisted Solution

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

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

** Missing <SomeReferenceName>

mx
0
 
LVL 75
ID: 35141282
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35141284
<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
ID: 35141413
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
 
LVL 21
ID: 35141425
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
ID: 35156423
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
ID: 35157856
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
ID: 35158874
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
ID: 35159792
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
ID: 35159820
"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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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 …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

815 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

9 Experts available now in Live!

Get 1:1 Help Now