Databases used

Hey I would personally not even start deving a access based app, but that's me. I still would not assume that a lot of people want to move to sql server. access is simple for a lot of people because it's portable. If you want to be on the safe side just make everything odbc compliant and you don't have to worry about the backend, the just define their connection string.

It's useful to rememebr that there's no such thing as an access data base. Access is a pc client program that currently uses the Jet 4.0 data base engine. In the past, access has used other data base engines. In the future, access will be using a version of MSDE - aka MSSQL-lite, aka MSDE2005, aka Access/MSDE.

You can already use Access with MSSQL/MSDE and MS is working to make the distribution of Access/MSDE data bases within networks closer to the ease of distribution of the current .mdb Access/Jet data bases. They are also engaged in developing better conversion programs from .mdb's to MSDE/MSSQL. Some of what they're doing entails modifying MSSQL server to include some Jet functionality.

One issue MS has to work out is licensing for web servers - will they bundle Access/MSDE under whatever name as a freebie, will the hosting company have to have a full mssql license, will Access/MSDE run on the web server or on a separate server as MSSQL does.

My thought is that within a couple of years Access/Jet will be going the way of the dinosaur and Pascal Programming.

EDIT: But Gullanian's point is like a Smith & Wesson - it beats 4 Aces.

Edited by dpyers

Yep, thats why in the connection string it uses jet as the provider

My thoughts exactly, Access/Jet as it currently is, will die pretty soon, and it's not worth the investment in time, also if Access will be MSDEized chances are that it will support all MSSQL specifics, so all MSSQL features will be supported (hope so).

Yeah the good old Pascal, loved it back in the 80's.

As far as this poll is concerned, it does not tell the whole story, 5 MSSQL / 0 Access (as of now) - Most people are not voting I suspect, so it's difficult to build a good picture, still, let it run for a few more days.