By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,629 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

Northwind from 2007 to 2010

P: 2
Hello.!
I've been using for a while northwind 2007.
How can I keep my records and upgrade it to the new 2010 version.?
Is it possible.?

Thank you.!

Denise
Jul 27 '12 #1

✓ answered by Seth Schrock

I'm not sure how much of a conversion there is between Access 2007 and 2010 since they both use the new accdb format. However, you can import all of your tables, forms, etc. into a new Access 2010 database by going to the External Data tab in the ribbon bar, clicking Access in the Import & Link group and then following the wizard. I'm not sure why you aren't able to copy them over. I have done so on a few occasions and never had a problem.

Share this Question
Share on Google+
8 Replies


Seth Schrock
Expert 2.5K+
P: 2,930
You should be able to open the 2007 database using Access 2010. Then any changes that you make will be in Access 2010.
Jul 27 '12 #2

P: 2
Thanks.!
I did explain myself right...
I'd like to convert my 2007 db to the new format..
I tried to copy my current tables and stuff, but it doesn't let me..
Is there anyway to do that?
Jul 27 '12 #3

P: 50
Hi Denise

Open your 2007 database in Access 2010, after it has loaded click the 'Office Button' (The circle, Extreme Top Lefthand Corner of screen) in the dropdown menu that appears choose 'Save As' then click the 'Access 2010' option under the 'Save the database in another format' and give it a name and location and that is it.

Kind regards
Jul 27 '12 #4

Seth Schrock
Expert 2.5K+
P: 2,930
I'm not sure how much of a conversion there is between Access 2007 and 2010 since they both use the new accdb format. However, you can import all of your tables, forms, etc. into a new Access 2010 database by going to the External Data tab in the ribbon bar, clicking Access in the Import & Link group and then following the wizard. I'm not sure why you aren't able to copy them over. I have done so on a few occasions and never had a problem.
Jul 27 '12 #5

Seth Schrock
Expert 2.5K+
P: 2,930
@John I don't think that Access differentiates between Access 2007 and 2010 in the Save As menu.
Jul 27 '12 #6

P: 50
@Seth Schrock
I only have 2007 (being a poor person) If there was a difference the saveAs would have been available. I think the upgrade is more functionality than format.
Jul 27 '12 #7

Jerry Maiapu
100+
P: 259
You need to have access 2010 to be able to convert to 2010 format. without having access 2010 installed I do not think of a method to covert from 2007 to 2010.

Once installed use john garvey's (post 5) or Seth Schrock's (post 6) method to convert ie either by save as or exporting the objects.

Cheers!
JM
Jul 28 '12 #8

zmbd
Expert Mod 5K+
P: 5,285
Sigh... you'd think that one accdb would be as good as another accdb...

http://allenbrowne.com/access2007.html
http://msdn.microsoft.com/en-us/office/cc907897.aspx
Good ole Allen...

-z
Aug 1 '12 #9

Post your reply

Sign in to post your reply or Sign up for a free account.