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

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
ADawnAsked:
Who is Participating?
 
dwaldnerConnect With a Mentor Commented:
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
 
dwaldnerCommented:
http://forums.devarticles.com/archive/t-4637

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

Dan
0
 
mantaraeConnect With a Mentor Commented:
Access has a tool to convert an existing Access database into a SQL Server database.

Tools --> Database Utilities --> Upsizing Wizard
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
dwaldnerCommented:
That tool is dependent on your version of access...I have Access 2002 and I don't have that option
0
 
dwaldnerCommented:
Awesome call mantarae...learn something new everyday on this site :)
0
 
ADawnAuthor Commented:
Now that everyone is excited, does this tool convert Access 97 to MSDE?

Amanda
0
 
mantaraeCommented:
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
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.