April 2007
Beginner
573 pages
12h 41m
English
Content preview from Beginning Access™ 2007 VBA
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
10.5. Migrating an Existing Access Database to an Access Project
Microsoft Access has an Upsizing Wizard to help you migrate existing Access databases to SQL Server. In this section, I cover some tips for making the migration smoother. You will then upsize the Northwind sample database that comes with Microsoft Access so you can see how the process works.
10.5.1. Changes to an Existing Database
Before migrating your existing Access application to an Access Project that uses SQL Server, here are some tips that will make the migration go more smoothly:
Consider removing any spaces in your table names and, of course, if you change the name, also change all the places that reference the table name. If you do not remove them, you will later have to use brackets to refer to SQL Server tables with spaces in their names (for example, [Table Name]).
Make sure that each table has a unique index. If you have established primary keys, that should be sufficient.
Make a backup copy of the ACCDB file in case things go wrong.
Check the dates in your Access tables. Most problems with upsizing occur with date conversions. For example, Access and SQL Server have different date ranges that are acceptable. SQL Server covers only the period from Jan 1, 1753 to Dec 31, 9999. Access allows dates in the range from Jan 1, 100 to Dec 31, 9999.
With these tips in mind, let's walk through using the Upsizing Wizard to see how this works.
10.5.2. Using the Upsizing Wizard
As previously mentioned, you can use ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.