Solved

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

Posted on 2004-07-30
8
326 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
  • 4
  • 3
8 Comments
 
LVL 3

Accepted Solution

by:
dwaldner earned 20 total points
Comment Utility
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
Comment Utility
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
Comment Utility
Access has a tool to convert an existing Access database into a SQL Server database.

Tools --> Database Utilities --> Upsizing Wizard
0
 
LVL 3

Expert Comment

by:dwaldner
Comment Utility
That tool is dependent on your version of access...I have Access 2002 and I don't have that option
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 7

Expert Comment

by:mantarae
Comment Utility
0
 
LVL 3

Expert Comment

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

Author Comment

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

Amanda
0
 
LVL 7

Expert Comment

by:mantarae
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This video discusses moving either the default database or any database to a new volume.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

771 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now