Solved

Convert an MS Access database to MSDE and or SQL Server?

Posted on 2004-07-30
8
369 Views
Last Modified: 2006-11-17
Hello,

I'm moving me VB6 application to ASP.Net. I need to know if I can convert my MS Access 97 database to MSDE. If it can't, can I convert it to SQL Server?

Amanda
0
Comment
Question by:ADawn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 3

Accepted Solution

by:
dwaldner earned 20 total points
ID: 11676430
Absolutely, you can convert MS Access to SQL Server...if memory serves me correctly, MSDE is simply SQL Server with a little bit crippled.  For the most part, you can do what you want.  For help on how to do this, there are numerous articles on the web on how to do what you want.
0
 
LVL 3

Expert Comment

by:dwaldner
ID: 11676440
http://forums.devarticles.com/archive/t-4637

Here's just one example of the articles that you'll find useful...cheers

Dan
0
 
LVL 7

Assisted Solution

by:mantarae
mantarae earned 30 total points
ID: 11677381
Access has a tool to convert an existing Access database into a SQL Server database.

Tools --> Database Utilities --> Upsizing Wizard
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
LVL 3

Expert Comment

by:dwaldner
ID: 11677399
That tool is dependent on your version of access...I have Access 2002 and I don't have that option
0
 
LVL 3

Expert Comment

by:dwaldner
ID: 11677520
Awesome call mantarae...learn something new everyday on this site :)
0
 

Author Comment

by:ADawn
ID: 11677848
Now that everyone is excited, does this tool convert Access 97 to MSDE?

Amanda
0
 
LVL 7

Expert Comment

by:mantarae
ID: 11678299
Well, I can't find anything that conclusively says Access 97 can upsize to MSDE. However, both Access 2000 & 2002 can, so I assume 97 can also.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

628 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