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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
All Courses

From novice to tech pro — start learning today.