Are Access databases (.mdb) deprecated?
-
The Microsoft data access components (MDAC) portion of MSDN states that MS JET has been depreciated. Does this mean that the standard access database (.mdb) that we have all grown to know and hate is also going away? If so what's going to replace it? I need to create a small to medium sized database (100,000 rows per table, sequential access only) that can reside on users machines without a lot of overhead and with minimal cost. I would also perfer to use MS technologies. Also does anyone know of any DB that encrypts the data before it's stored?
-
The Microsoft data access components (MDAC) portion of MSDN states that MS JET has been depreciated. Does this mean that the standard access database (.mdb) that we have all grown to know and hate is also going away? If so what's going to replace it? I need to create a small to medium sized database (100,000 rows per table, sequential access only) that can reside on users machines without a lot of overhead and with minimal cost. I would also perfer to use MS technologies. Also does anyone know of any DB that encrypts the data before it's stored?
MSDE is replacing MS JET; I believe MSDE is also called SQL Server Personal Edition; but it also lacks the visual tools for using it. That is where Access comes in; as it can connect to MSDE and create databases. At least that is what something from MS said ;) James "And we are all men; apart from the females." - Colin Davies
-
MSDE is replacing MS JET; I believe MSDE is also called SQL Server Personal Edition; but it also lacks the visual tools for using it. That is where Access comes in; as it can connect to MSDE and create databases. At least that is what something from MS said ;) James "And we are all men; apart from the females." - Colin Davies
Cool, thanks.
-
MSDE is replacing MS JET; I believe MSDE is also called SQL Server Personal Edition; but it also lacks the visual tools for using it. That is where Access comes in; as it can connect to MSDE and create databases. At least that is what something from MS said ;) James "And we are all men; apart from the females." - Colin Davies
James T. Johnson wrote: MSDE is also called SQL Server Personal Edition; Is this an available download, do you know ? Christian We're just observing the seasonal migration from VB to VC. Most of these birds will be killed by predators or will die of hunger. Only the best will survive - Tomasz Sowinski 29-07-2002 ( on the number of newbie posters in the VC forum ) Cats, and most other animals apart from mad cows can write fully functional vb code. - Simon Walton - 6-Aug-2002
-
James T. Johnson wrote: MSDE is also called SQL Server Personal Edition; Is this an available download, do you know ? Christian We're just observing the seasonal migration from VB to VC. Most of these birds will be killed by predators or will die of hunger. Only the best will survive - Tomasz Sowinski 29-07-2002 ( on the number of newbie posters in the VC forum ) Cats, and most other animals apart from mad cows can write fully functional vb code. - Simon Walton - 6-Aug-2002
Looks like it only comes bundled with other ms products. http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp[^]
-
MSDE is replacing MS JET; I believe MSDE is also called SQL Server Personal Edition; but it also lacks the visual tools for using it. That is where Access comes in; as it can connect to MSDE and create databases. At least that is what something from MS said ;) James "And we are all men; apart from the females." - Colin Davies
James T. Johnson wrote: I believe MSDE is also called SQL Server Personal Edition Actually its called SQL Server 2000 'Desktop Engine' previosuly known as 'Microsoft Data Engine (MSDE) 1.0' Personal Edition is a different version, as I recall there are five editions(way overdone) [Edit] previosuly known = earlier versions known as [/Edit]
-
James T. Johnson wrote: MSDE is also called SQL Server Personal Edition; Is this an available download, do you know ? Christian We're just observing the seasonal migration from VB to VC. Most of these birds will be killed by predators or will die of hunger. Only the best will survive - Tomasz Sowinski 29-07-2002 ( on the number of newbie posters in the VC forum ) Cats, and most other animals apart from mad cows can write fully functional vb code. - Simon Walton - 6-Aug-2002
Christian Graus wrote: Is this an available download, do you know ? It comes with several tools from MS(each one behaves a tad bit differently), though just a warning it can be a big hassle(and thats not an exaggeration) to work with if you are expecting the average SQL server 2000 experience. For starters theres no EM tools. Trying to set up security can also be a headache(again no EM tools). There are also limits, such as the 2 GB per database though that might enough for small and medium sized projects. As for the actual download I don't believe the 2000 edition is available(I tried to look a while ago) Note: When you actually do look for docs, make sure your reading for the 2000 as many of the docs deal with the older version.
-
James T. Johnson wrote: I believe MSDE is also called SQL Server Personal Edition Actually its called SQL Server 2000 'Desktop Engine' previosuly known as 'Microsoft Data Engine (MSDE) 1.0' Personal Edition is a different version, as I recall there are five editions(way overdone) [Edit] previosuly known = earlier versions known as [/Edit]
I,ve downloaded MSDE from Microsoft's website in the past. Can't remember the URL though. To get the visual tools I installed a trial version of SQL Server 7.0 that came with a book.
-
MSDE is replacing MS JET; I believe MSDE is also called SQL Server Personal Edition; but it also lacks the visual tools for using it. That is where Access comes in; as it can connect to MSDE and create databases. At least that is what something from MS said ;) James "And we are all men; apart from the females." - Colin Davies
One of the advantages of mdb database for my use is, that it is a single file, which can be easily manipulated - installing, copying, backup, ... Am I right, if I suppose, that MSDE does it differently? Sonork 100.15206;PavelK
-
MSDE is replacing MS JET; I believe MSDE is also called SQL Server Personal Edition; but it also lacks the visual tools for using it. That is where Access comes in; as it can connect to MSDE and create databases. At least that is what something from MS said ;) James "And we are all men; apart from the females." - Colin Davies
Although MSDE replaces MS JET in Microsoft's ideal world, the Jet engine is still widely used, and is still available for download - it's just not a component of the MDAC package any more. But of course, it's unsure how much updating MS will do on the Jet engine (but it's on SP5 now, so they're still doing something!). One thing that I have a really hard time figuring out is whether I can distribute MSDE freely (provided I have bought a development tool such as VC++6.0 (no .NET for me, thank you)). Or maybe my customers can download MSDE? I'm not sure. Insights, anybody? Cheers Steen. "To claim that computer games influence children is ridiculous. If Pacman had influenced children born in the 80'ies we would see a lot of youngsters running around in dark rooms eating pills while listening to monotonous music"
-
MSDE is replacing MS JET; I believe MSDE is also called SQL Server Personal Edition; but it also lacks the visual tools for using it. That is where Access comes in; as it can connect to MSDE and create databases. At least that is what something from MS said ;) James "And we are all men; apart from the females." - Colin Davies
That's right. But SQLServer2000 desktop front ends cannot be replaced that easy : MS Access provides no UI for user security access and so on,
And I swallow a small raisin.
-
Although MSDE replaces MS JET in Microsoft's ideal world, the Jet engine is still widely used, and is still available for download - it's just not a component of the MDAC package any more. But of course, it's unsure how much updating MS will do on the Jet engine (but it's on SP5 now, so they're still doing something!). One thing that I have a really hard time figuring out is whether I can distribute MSDE freely (provided I have bought a development tool such as VC++6.0 (no .NET for me, thank you)). Or maybe my customers can download MSDE? I'm not sure. Insights, anybody? Cheers Steen. "To claim that computer games influence children is ridiculous. If Pacman had influenced children born in the 80'ies we would see a lot of youngsters running around in dark rooms eating pills while listening to monotonous music"
MSDE can be installed on any client computer for free. What you cannot install is the development environment (Access or SQL Server Tools). I haven't got any copy of MSDE here, but where I worked before we used it for commercial products and I was the one who had to look at all the legal issues. The statement is somewhere in the MSDE EULA. Since they want MSDE to replace mdb files and you can copy an mdb file to any place you want, they had no other way out that letting MSDE be installed for free on any computer. Regards Francisco Viella Why am I still a bronze member?
-
MSDE can be installed on any client computer for free. What you cannot install is the development environment (Access or SQL Server Tools). I haven't got any copy of MSDE here, but where I worked before we used it for commercial products and I was the one who had to look at all the legal issues. The statement is somewhere in the MSDE EULA. Since they want MSDE to replace mdb files and you can copy an mdb file to any place you want, they had no other way out that letting MSDE be installed for free on any computer. Regards Francisco Viella Why am I still a bronze member?
Francisco Viella wrote: MSDE can be installed on any client computer for free From http://www.microsoft.com/sql/techinfo/development/2000/MSDEintegration.asp[^]: Developers can freely distribute MSDE 2000 solutions built with SQL Server 2000 Developer Edition, Microsoft Visual Studio® .NET development tools, or with Microsoft Office 2000 Developer edition. See the End-User License Agreement (EULA) for the full redistribution and royalty terms. And for MSDE 1.0 (SQL Server 7.0), from http://msdn.microsoft.com/library/default.asp?URL=/library/backgrnd/html/msdeforvs.htm[^]: The Microsoft Data Engine (MSDE) is a fully SQL Server-compatible database engine that can be used for desktop and shared database solutions built with either Visual Studio 6.0 or Access 2000. In addition, solutions built with MSDE for Visual Studio 6.0 or Office 2000 Developer can be distributed royalty-free. MSDE is based on SQL Server technology and is fully compatible with SQL Server 7.0. When used in Access 2000, MSDE is an attractive alternative to Jet—the default Access 2000 database engine. In addition, MSDE is available to Visual Studio 6.0 developers who wish to build custom applications with embedded databases that are SQL compliant. So I guess with VC++6.0 I can distribute MSDE 1.0 but not MSDE2000, and the clients cannot download MSDE in any version without having either SQL Server or Office. Have I gotten it right? Francisco Viella wrote: Since they want MSDE to replace mdb files and you can copy an mdb file to any place you want, they had no other way out that letting MSDE be installed for free on any computer. Well, mdb files are not the Jet engine, and MSDE is not the SQL Server database. So MSDE replaces Jet, not the mdb files. And from the links above I don't think that MSDE can be installed freely on any computer I guess asking a question and then answering it myself is not very polite, so please accept my apologies. I just thought I had gotten it all wrong. Cheers Ste
-
The Microsoft data access components (MDAC) portion of MSDN states that MS JET has been depreciated. Does this mean that the standard access database (.mdb) that we have all grown to know and hate is also going away? If so what's going to replace it? I need to create a small to medium sized database (100,000 rows per table, sequential access only) that can reside on users machines without a lot of overhead and with minimal cost. I would also perfer to use MS technologies. Also does anyone know of any DB that encrypts the data before it's stored?
Does this mean that JET will not be installed by default on Windows2000? Drinking In The Sun Forgot Password?
-
Francisco Viella wrote: MSDE can be installed on any client computer for free From http://www.microsoft.com/sql/techinfo/development/2000/MSDEintegration.asp[^]: Developers can freely distribute MSDE 2000 solutions built with SQL Server 2000 Developer Edition, Microsoft Visual Studio® .NET development tools, or with Microsoft Office 2000 Developer edition. See the End-User License Agreement (EULA) for the full redistribution and royalty terms. And for MSDE 1.0 (SQL Server 7.0), from http://msdn.microsoft.com/library/default.asp?URL=/library/backgrnd/html/msdeforvs.htm[^]: The Microsoft Data Engine (MSDE) is a fully SQL Server-compatible database engine that can be used for desktop and shared database solutions built with either Visual Studio 6.0 or Access 2000. In addition, solutions built with MSDE for Visual Studio 6.0 or Office 2000 Developer can be distributed royalty-free. MSDE is based on SQL Server technology and is fully compatible with SQL Server 7.0. When used in Access 2000, MSDE is an attractive alternative to Jet—the default Access 2000 database engine. In addition, MSDE is available to Visual Studio 6.0 developers who wish to build custom applications with embedded databases that are SQL compliant. So I guess with VC++6.0 I can distribute MSDE 1.0 but not MSDE2000, and the clients cannot download MSDE in any version without having either SQL Server or Office. Have I gotten it right? Francisco Viella wrote: Since they want MSDE to replace mdb files and you can copy an mdb file to any place you want, they had no other way out that letting MSDE be installed for free on any computer. Well, mdb files are not the Jet engine, and MSDE is not the SQL Server database. So MSDE replaces Jet, not the mdb files. And from the links above I don't think that MSDE can be installed freely on any computer I guess asking a question and then answering it myself is not very polite, so please accept my apologies. I just thought I had gotten it all wrong. Cheers Ste
Steen Krogsgaard wrote: In addition, solutions built with MSDE for Visual Studio 6.0 or Office 2000 Developer can be distributed royalty-free. This was the line that made us think that you can install MSDE on your clients computer for free, as long as you don't let him use it for his own developments. I don't think Microsoft would say solution and royalty-free in the same sentence if they were talking about my work, my work is royaltee free. Of cours, that was our own interpretation and, as such, it could be completely wrong. Out lawyer agreed with us, but he could be wrong too. ;) Why am I still a bronze member?
-
James T. Johnson wrote: MSDE is also called SQL Server Personal Edition; Is this an available download, do you know ? Christian We're just observing the seasonal migration from VB to VC. Most of these birds will be killed by predators or will die of hunger. Only the best will survive - Tomasz Sowinski 29-07-2002 ( on the number of newbie posters in the VC forum ) Cats, and most other animals apart from mad cows can write fully functional vb code. - Simon Walton - 6-Aug-2002
Christian Graus wrote: Is this an available download, do you know ? I believe it is and you are licensed for it if you have VS 6. Also I blieve you will find it under \Microsoft\MSDE on that Utilities and Patches CD I sent you many months ago. Michael Martin Australia mjm68@tpg.com.au "I personally love it because I can get as down and dirty as I want on the backend, while also being able to dabble with fun scripting and presentation games on the front end." - Chris Maunder 15/07/2002
-
James T. Johnson wrote: MSDE is also called SQL Server Personal Edition; Is this an available download, do you know ? Christian We're just observing the seasonal migration from VB to VC. Most of these birds will be killed by predators or will die of hunger. Only the best will survive - Tomasz Sowinski 29-07-2002 ( on the number of newbie posters in the VC forum ) Cats, and most other animals apart from mad cows can write fully functional vb code. - Simon Walton - 6-Aug-2002
http://www.asp.net/msde/default.aspx[^] Try that. It says it is a Web Matrix version but it should work for the basics. -:suss:Matt Newman / Windows XP Activist:suss: -Sonork ID: 100.11179
"You can't seriously believe that you could get away with suing someone over quoting text from a message posted in a public forum, can you?" - John Simmons -
One of the advantages of mdb database for my use is, that it is a single file, which can be easily manipulated - installing, copying, backup, ... Am I right, if I suppose, that MSDE does it differently? Sonork 100.15206;PavelK
Pavel Klocek wrote: Am I right, if I suppose, that MSDE does it differently? Yes, it behaves like SQL Server in that the files are 'hidden' to the application and you communicate to a service instead. James "And we are all men; apart from the females." - Colin Davies