?
Solved

Upgrading to 2010 from 2007, compatibility

Posted on 2013-06-29
5
Medium Priority
?
280 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
  • 2
  • 2
5 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 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 1000 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

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…
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
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…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month4 days, 9 hours left to enroll

601 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