Solved

Converting Access Database from 2003 to 2010

Posted on 2010-09-22
7
1,633 Views
Last Modified: 2013-11-28
A client for whom I have created several databases in Access 2003 will be upgrading to Access 2010 at the end of the year.  I am currently in the middle of developing a database for them, still  in 2003, that will be finished around the time that they will be upgrading.  I have three questions:

1) What should be done with their current Access 2003 databases?  Should I convert them or can they be used as is in Office 2010?

2) Should I continue to work on the new database in Access 2003 and then convert to 2010 once I've finished or should I convert now?  I don't have Access 2010 now, but I can get it soon if it would be better that way.

3) What are the difficulties / complications in converting a database from Access 2003 to Access 2010?

Thank you!
0
Comment
Question by:Saleve
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 166 total points
ID: 33737089
1. the a2003 db will run in a2010
2. Yes you can continue working with the A2003 database
3..
see and download the guide from here
http://office.microsoft.com/en-us/access-help/migrating-to-access-2010-from-access-2003-HA101886851.aspx
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 33737118
With access 2007 and I assume 2010 it has the ability to run older databases.

But you may still come across some issues like activex controls and vba code.

I think maybe have a look at the migration considerations up to 2007 as you will probably hit similar issues with 2010
http://technet.microsoft.com/en-us/library/cc178973%28office.12%29.aspx

some useful reading here also http://allenbrowne.com/access2007.html


I think its worth trying one of the databases and opening it up. Then make a note of any errors it finds.
Check the vba code (do debug/compile) and check the references.

0
 

Author Comment

by:Saleve
ID: 33737137
I've only used one activex control, the calendar.  Will this be a problem?
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 33737197
not sure, if you can upload a sample db with that activex control, i can test it.

in a2010 there is already a built in calendar that shows for date/time field controls.
0
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 167 total points
ID: 33737204
Saleve,

You may read some of my comments in response to your questions:

1) What should be done with their current Access 2003 databases?  Should I convert them or can they be used as is in Office 2010?

Though older versions of Access would run with Access 2010, I may suggest that converting it into the latest version would probably save you time in fixing errors in the future. We must put into consideration that Microsoft has priority concerns on releasing hot fixes and updates of the latest than the older version of Access. With this, it would be a good step to convert it now.

2) Should I continue to work on the new database in Access 2003 and then convert to 2010 once I've finished or should I convert now?  I don't have Access 2010 now, but I can get it soon if it would be better that way.

If you have a chance to get a copy of Access 2010, then my best bet is use the latest version right away. It will give you an edge in terms of learning the new features it can offer than those who are still using the 2003 version. (If you have the copy I recommend to read its Web Interface capability.)


3) What are the difficulties / complications in converting a database from Access 2003 to Access 2010?
So far not a big deal as long as you designed your Access 2003 database well.

Sincerely,

Ed
0
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 167 total points
ID: 33737242
dont think so. calendar should be okay. but still remember to check the vba
0
 

Author Closing Comment

by:Saleve
ID: 33737351
Thanks everyone, and thank you capricorn1 for offering to take a look at my calendar control.  I think that I will try the conversion and then get back to EE if I have any problems.
Saleve
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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 …

856 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