ADawn
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That tool is dependent on your version of access...I have Access 2002 and I don't have that option
For Access 97: http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm
For Access 2002: http://support.microsoft.com/default.aspx?scid=kb;en-us;330468
For Access 2002: http://support.microsoft.com/default.aspx?scid=kb;en-us;330468
Awesome call mantarae...learn something new everyday on this site :)
ASKER
Now that everyone is excited, does this tool convert Access 97 to MSDE?
Amanda
Amanda
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.
Here's just one example of the articles that you'll find useful...cheers
Dan