473,322 Members | 1,610 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Northwind from 2007 to 2010

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.

8 2611
Seth Schrock
2,965 Expert 2GB
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
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
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
2,965 Expert 2GB
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
2,965 Expert 2GB
@John I don't think that Access differentiates between Access 2007 and 2010 in the Save As menu.
Jul 27 '12 #6
@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
259 100+
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
5,501 Expert Mod 4TB
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

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

Similar topics

9
by: Xah Lee | last post by:
REQUIREMENTS FOR A VISUALIZATION SOFTWARE SYSTEM FOR 2010 Xah Lee, 2007-03-16 In this essay, i give a list of requirements that i think is necessary for a software system for creating...
10
by: Arno R | last post by:
Hi all, So I bought a new laptop 10 days ago to test my apps with Vista. (home premium) Apparently Office 2007 is pre-installed. (a time limited but complete test version, no SP1) So I take the...
4
by: MrDeej | last post by:
Hello! I have a complex .accdb database which i after yesterdays changes cannot enter the VBA anymore. Most of the forms and all tables/queries works fine. But one of the forms causes it to hang...
5
by: jaad | last post by:
Hello, I have a database that was written in access 2007 on my pc. I wanted to work off site with the database so I uploaded it onto my laptop which is loaded with access 2010 beta. When I...
1
by: phillikl | last post by:
Good day, First would like to say I use this site to find more trivial stuff than anyplace else.. THANKS!!! Been looking for a few hours on this and seem to be not asking the correct...
0
by: Lyu KingT | last post by:
hi, i need to control the right of a Office document in my Visual Studio Projects, so how to enable or disable the print, what abou edit, save..... i try to fellow the video How Do I: Hi-jack...
0
by: phill86 | last post by:
Hi, I have created a database in 2010 and have opened it in 2007 and it has previously work. When i now try and open the 2010 database in 2007 I get unrecognised format error I have created a...
1
by: colsoft | last post by:
Please I want to know i how i can search for a specific record in a report and print that record without using the arrows at the bottom. Like show a dialog or use an input box to search through the...
1
dsatino
by: dsatino | last post by:
My company has recently been upgrading all operating systems to Windows 7 and all MS Office products to the 2010 version. I've managed to update/modify all code to run on both the .mdb and .accdb...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.