Is MS Access and Jet becoming obsolete?
Is MS Access and Jet becoming obsolete?
I'm looking for a free database to use for a simple PC desktop application and MSDE seems like overkill for the type of desktop application I want to build. Yet at the same time I don't want to use some technology that is going obsolete. Please give me your input. Thanks
[335 byte] By [
Rigel] at [2007-11-19 2:30:12]
# 1 Re: Is MS Access and Jet becoming obsolete?
No its not, yes it's fine to use.
Hope this helps,
- Nigel
NigelQ at 2007-11-9 13:39:06 >
# 2 Re: Is MS Access and Jet becoming obsolete?
Thanks NigelQ!
Here is the reason why I was concerned. I found this posting on an internet site:
Now given that...
1 DAO is obsolete
2 Jet relies on DAO
3 SQL server is a proper client-server database
4 Access 2000 and 2002 come with MSDE AND provide a goor visual interface
to SQL Server
5 Access uses DAO internally (to store its database objects)
6 PCs have loads of memory and huge disks
7 SQL Server is a vastly better database product than Jet - if only
because it has logging and proper backups
8 SQL Server is a proper client-server database
... then clearly both from MS and us developers point of view Jet's days are
numbered. Of course there is a learning curve... but then that is the
industry we are in and we are all used to that
Anyone else have any other type of input or comments please feel free to post.
Rigel at 2007-11-9 13:40:05 >
# 3 Re: Is MS Access and Jet becoming obsolete?
I'm glad the feedback helped.
The comments you posted are common misconceptions. SQL will never replace Access for several simple reasons...
Without the nice front end supplied with SQL Server, the MSDE is very difficult to use. In addition, the overhead in terms of processing power and memory required to run SQL Server versus Access is huge.
Using SQL Server you need to adhere to many security protocols in order to set it up initially, with Access you can provide significant security, but if you don't need it, setting up an installation or application is extremely easy (copying a single file).
Access (Jet) is good for small, simple applications. SQL (MSDE) is good for larger, more secure applications.
There is one comment from your clipping that I would tend to agree with, and that is the demise of DAO for database communication. Mostly ADO has become the easiest database connection medium to use these days.
There are obviously alternatives to both of these databases that you have not mentioned too, which should probably be considered also.
Hope this helps,
- Nigel
NigelQ at 2007-11-9 13:41:14 >
# 4 Re: Is MS Access and Jet becoming obsolete?
Excellent thanks for the clarification Nigel.
Mind if I ask one more question. You mentioned that there are alternatives besides Access. What alternatives are there for a smaller free database like Access/Jet?
Thanks!
Rigel at 2007-11-9 13:42:07 >
# 5 Re: Is MS Access and Jet becoming obsolete?
SQLite is one that I've heard of (never used), and you can also write your own database based on your needs, which may be quicker/more efficient than the others listed here (with other benefits reduced)
Other options may be FoxPro, and I think DBase is still around. I'm sure there are scores of others that I've not tried either.
The point was that there are indeed others out there, just so that you're aware.
Hope this helps,
- Nigel
NigelQ at 2007-11-9 13:43:16 >
# 6 Re: Is MS Access and Jet becoming obsolete?
If your are gonna use jet and DAo then does not matter if you have access or not
As Nigel put it you can write ur own database software according to your needs.
I actually did a app which had an access like interface to create and managa dbs.
It was all based on jet and DAO
and jet's not going anywhere any sooner
Regards
venAdder
# 7 Re: Is MS Access and Jet becoming obsolete?
It will all change soon.
MsSQL is now (SQL 2005 Express as I remember) targeting embeded solutions too.
Krzemo at 2007-11-9 13:45:13 >
# 8 Re: Is MS Access and Jet becoming obsolete?
It will all change soon.
MsSQL is now (SQL 2005 Express as I remember) targeting embeded solutions too.
This is very interesting, but it doesn't address the original question; whether Access/Jet were becoming obsolete.
Regardless of how useful or successful SQL 2005 Express is, when have Microsoft ever got something 100% correct at launch - never. So, even if this thing is the best database in the world, ir will be 2007 at the earliest before everyone is using it.
:lol:
Regards,
- Nigel
NigelQ at 2007-11-9 13:46:16 >
