Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help on MSDE

Status
Not open for further replies.

bzac

Programmer
Dec 20, 2000
55
US
I heard there is a common data engine for Access 2000 and SQL Server. Is that MSDE?. How can I install/Implement it?. How can I use Access2000 database with that engine? How can I trasfer Access2000 db to SQL Server?

 
MSDE is the desktop version of SQL 7. It has nothing in common with Access.

If I were developing a client-server application today, I'd have my developers running MSDE (with one person the designated DBA), and when the application got closer to being released, then I'd buy a copy of SQL Server to test against. If you've got a developer who is working from home, this could be handy, too.

It is also useful for when you've got salespeople with laptops. You can copy the database and logfile from a SQL 7 machine and put them on the laptop and once you point the ODBC at it, the software will run the same.

Only limitation is 2gb max database size. Which is not likely to be much of a problem in a demo/sales environment.

Chip H.
 
Thank you very much Chip H. for your valid information
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top