How do I upsize MS Access 2003 DB to MS SQL Server DB?

Is there a way to upsize MS Access db from MS Server Management Studio? I can't seem to find the Upsizing wizard from my MS Access 2003 installer. I'm using MS Server 2008 Express Edition.
0nepieceAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I'd try using the SQL Server Migration Assistant:

http://www.microsoft.com/sqlserver/2008/en/us/assessment-tools.aspx
0
 
Meir RivkinFull stack Software EngineerCommented:
in the MS Access menu goto Tools menu, point to Database Utilities, and then click Upsizing Wizard.
If the wizard doesn't start

This could be due to the fact that Access is running in sandbox mode but Microsoft Jet 4.0 SP8 or later is not installed on your computer. Jet 4.0 SP8 or later is required for Access to be fully functional when sandbox mode is enabled.

For more information about installing the Jet upgrade, see the Office Online article About Microsoft Jet 4.0 SP8 or later, at http://office.microsoft.com/assistance/preview.aspx?AssetID=HA010489351033.

for more information about upsizing MS Access 2003 check http://office.microsoft.com/en-us/access/CH062526781033.aspx
0
 
0nepieceAuthor Commented:
Umm I'm trying I choose to create a new db this error comes up. Please refer to the image.
upsize-wizard.JPG
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Meir RivkinFull stack Software EngineerCommented:
u get server doesn't exists or denied access.
change (local) to the DB server.
0
 
0nepieceAuthor Commented:
Ok got that. But it says that upsize wizard only works with higher versions of  MS SQL server. But I'm already using MS SQL Server 2008 Express Edition. How come this happens?
dsource.JPG
0
 
Meir RivkinFull stack Software EngineerCommented:
pls follow this post from microsoft:
http://support.microsoft.com/kb/838594
0
 
0nepieceAuthor Commented:
Hi, I'm sorry but I don't know where to locate the "appropriate DSN" and it's also not clear to me what DSN means.
0
 
Meir RivkinFull stack Software EngineerCommented:
the problem might occur due the fact that the Upzising Wizard makes a check on the version of SQL-Server if it's not SQL-Server 6.5, 7 or 2000. Using or not a DSN change nothing to
that.
also possible that you might have a connection or a login issue.
in addition, you should be using the SQL Native Client, instead of the generic SQL Server
ODBC driver.

u might wanna try the SQL-Server Migration Assistant for Access (SSMA-A) as LSMConsulting suggested:

http://www.microsoft.com/downloads/details.aspx?FamilyID=d842f8b4-c914-4ac7-b2f3-d25fff4e24fb&displaylang=en
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The link provided by sedgwick is for SQL Server 2005 - be careful, as you'll get better results using one for the specific version of SQL Server you're using, which I believe is 2008 Express Edition.
0
 
Meir RivkinFull stack Software EngineerCommented:
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Yes .... which points to the same file as the link I posted earlier ;)
0
 
0nepieceAuthor Commented:
This one did the job quick and easy! Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.