Solved

Upgrading to 2010 from 2007, compatibility

Posted on 2013-06-29
5
269 Views
Last Modified: 2013-06-30
Experts,

I have a db mainly developed in 2007.  I am upgrading to 2010.  I have heard about the date picker not being compatible.  Is this true or is it not compatible in 2013?  I have some reports and forms built with the report wizard.  

Is it advised to reimport all object into a blank 2010 db?  
Any other known issues I am likely to encounter?  

thank you
0
Comment
Question by:pdvsa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 39286948
In A2007, you had MSCAL.OCX which contains the date picker.
In A2010, this is no longer supported and has been replaced with the Built-In Date Picker, available on any Text Box, and will display anytime the Control Source is a date/time data type.

"Is it advised to reimport all object into a blank 2010 db"
This is always the best approach. And before you do this, be SURE your app Compiles in A2007. If not, find issue(s) and fix.

mx
0
 
LVL 75
ID: 39286950
"Any other known issues I am likely to encounter?  "
It's really hard to say. Maybe, maybe not.
Be sure your app is in a Trusted Location, and that Macro Security is set to Low (always enable macros setting).

mx
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 250 total points
ID: 39287697
Is this app used by multiple users?
If so you may want to hold of moving the development machine to 2010.

This is because once you start making design changes to the app in 2010, you may not be able to convert the DB back to the 2007 format, ...(if any 2007 users are having problems...)

JeffCoachman
0
 

Author Comment

by:pdvsa
ID: 39288105
Thank you.  

Jeff, the app is used by a couple people.  Everyone in our group is being upgraded to win 7 and office 2010.
0
 

Author Closing Comment

by:pdvsa
ID: 39288109
Thank you .  I had to choose a best solution.  All answers are best to me.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
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 …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

623 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