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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.