Solved

Converting 2003 to 2010

Posted on 2011-03-15
11
347 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
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
 
LVL 119

Expert Comment

by:Rey Obrero
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

863 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

27 Experts available now in Live!

Get 1:1 Help Now