|
|
Hi all! I'm quite confused. Is it true that MDB is deprecated? Will
Microsoft release a next Access version? Or will they just move to SQL? If
not, will they continue supporting DAO and Access related technologies?
I have read so many lose fragments. I read that the next version of Windows
will use a SQL-driven file system, so database technology seem to be part of
the OS.
Any replies, or links greatly appreciated. Thanks!
|
|
"Nando" <nospam[ at ]no.spam> wrote:
[Quoted Text] >Hi all! I'm quite confused. Is it true that MDB is deprecated?
Somewhat. A2007 has a new format called ACCDB which supports new
complex data types which are compatible with SharePoint. However
A2007 also quite nicely supports MDBs.
>Will
>Microsoft release a next Access version? Or will they just move to SQL? If
>not, will they continue supporting DAO and Access related technologies?
I don't speak for Microsoft. However I know that MS are working on
the next version.
However keep in mind that SQL Server is a data storage mechanism.
Access, and many other products, allow you access, no pun intended, to
that data. It just so happens that Access is one of the best Rapid
Development tools out there for database apps. Access also allows
you to store data in tables in MDBs or ACCDBs.
Office and Windows are Microsoft's largest revenue streams. Microsoft
is not about to abandon Access any time soon.
>I have read so many lose fragments. I read that the next version of Windows
>will use a SQL-driven file system, so database technology seem to be part of
>the OS.
That feature is called Win FS presumably Windows File System. Which
didn't make it into Windows Vista.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
|
|
Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
"Tom Wickerath MDB" <tom_wickerath[ at ]hotmail.com> wrote in message
news:uCY2PpZnHHA.5068[ at ]TK2MSFTNGP05.phx.gbl...
[Quoted Text] > yes, of course MDB is depecrated
>
> DAO is obsolete, MDB is obsolete
>
> don't listen to anyone else
>
>
> "Nando" <nospam[ at ]no.spam> wrote in message
> news:8ON4i.32971$p47.2715[ at ]bgtnsc04-news.ops.worldnet.att.net...
>> Hi all! I'm quite confused. Is it true that MDB is deprecated? Will
>> Microsoft release a next Access version? Or will they just move to SQL?
>> If not, will they continue supporting DAO and Access related
>> technologies?
>>
>> I have read so many lose fragments. I read that the next version of
>> Windows will use a SQL-driven file system, so database technology seem to
>> be part of the OS.
>>
>> Any replies, or links greatly appreciated. Thanks!
>>
>
|
|
On Wed, 23 May 2007 17:27:45 -0700, "Tom Wickerath MDB"
<tom_wickerath[ at ]hotmail.com> wrote:
[Quoted Text] >yes, of course MDB is depecrated
>
>DAO is obsolete, MDB is obsolete
>
>don't listen to anyone else
And don't listen to Aaron K.empf masquerading as Tom Wikerath.
Aaron, you're going too far. You've been over the line for some time, posting
a lot of lies, but pretending to be someone you're not (someone with a
deservedly better reputation) is vile.
John W. Vinson [MVP]
|
|
Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
"Tom Wickerath MDB" <tom_wickerath[ at ]hotmail.com> wrote in message
news:%237H6oVbnHHA.5052[ at ]TK2MSFTNGP04.phx.gbl...
[Quoted Text] > John
>
> just because you're a jet pussy; that doesn't mean that people shoudln't
> listen to me
>
> of course they should listen to me
>
> MDB is depecrated
> spit on anyone that tells you otherwise
>
>
>
> "John W. Vinson" <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> wrote in message
> news:qct953hv749l17f83d8bdu0d4c7d3vrvio[ at ]4ax.com...
>> On Wed, 23 May 2007 17:27:45 -0700, "Tom Wickerath MDB"
>> <tom_wickerath[ at ]hotmail.com> wrote:
>>
>>>yes, of course MDB is depecrated
>>>
>>>DAO is obsolete, MDB is obsolete
>>>
>>>don't listen to anyone else
>>
>> And don't listen to Aaron K.empf masquerading as Tom Wikerath.
>>
>> Aaron, you're going too far. You've been over the line for some time,
>> posting
>> a lot of lies, but pretending to be someone you're not (someone with a
>> deservedly better reputation) is vile.
>>
>> John W. Vinson [MVP]
>
|
|
On Wed, 23 May 2007 20:41:45 -0700, "Tom Wickerath MDB"
<tom_wickerath[ at ]hotmail.com> wrote:
[Quoted Text] >John
>
>just because you're a jet pussy; that doesn't mean that people shoudln't
>listen to me
>
>of course they should listen to me
>
>MDB is depecrated
You're lying, Aaron. Please get some help. You need it.
John W. Vinson [MVP]
|
|
Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
"Tom Wickerath" <tom_wickerath[ at ]hotmail.com> wrote in message
news:eLzl5LdnHHA.4032[ at ]TK2MSFTNGP02.phx.gbl...
[Quoted Text] > I'm lying?
>
<SNIPPED>
>
> "John W. Vinson" <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> wrote in message
> news:s94a539p4d8ajctlhp0504t3h8vo46sn6p[ at ]4ax.com...
>> On Wed, 23 May 2007 20:41:45 -0700, "Tom Wickerath MDB"
>> <tom_wickerath[ at ]hotmail.com> wrote:
>>
>>>John
>>>
>>>just because you're a jet pussy; that doesn't mean that people shoudln't
>>>listen to me
>>>
>>>of course they should listen to me
>>>
>>>MDB is depecrated
>>
>> You're lying, Aaron. Please get some help. You need it.
>>
>> John W. Vinson [MVP]
>
>
|
|
Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
"Tom Wickerath" <tom_wickerath[ at ]hotmail.com> wrote in message
news:uAJAVMdnHHA.3736[ at ]TK2MSFTNGP03.phx.gbl...
[Quoted Text] > tell me john-- is Tony Toews wrong?
>
> he agrees that MDB is depecrated
>
> and the new format?
> I'll be all about the new format sometime soon.
>
> but i'll sure as hell never use JET or DAO
>
>
>
> "John W. Vinson" <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> wrote in message
> news:s94a539p4d8ajctlhp0504t3h8vo46sn6p[ at ]4ax.com...
>> On Wed, 23 May 2007 20:41:45 -0700, "Tom Wickerath MDB"
>> <tom_wickerath[ at ]hotmail.com> wrote:
>>
>>>John
>>>
>>>just because you're a jet pussy; that doesn't mean that people shoudln't
>>>listen to me
>>>
>>>of course they should listen to me
>>>
>>>MDB is depecrated
>>
>> You're lying, Aaron. Please get some help. You need it.
>>
>> John W. Vinson [MVP]
>
>
|
|
"Nando" <nospam[ at ]no.spam> wrote in
news:8ON4i.32971$p47.2715[ at ]bgtnsc04-news.ops.worldnet.att.net:
[Quoted Text] > Is it true that MDB is deprecated?
No. It's not true. See:
http://technet2.microsoft.com/Office/en-us/library/1dce641e-ba1c-446a
-8ff2-221769a58ba51033.mspx?mfr=true
Access Data Projects (ADPs)
An Access Data Project is an OLE document file, like the .xls
or.doc file formats. It contains forms, reports, macros, VBA
modules, and a connection string. All tables and queries are
stored in SQL Server. The ADP architecture was designed to create
client-server applications. Because of this, there is a limit to
the number of records that Access returns in any recordset. This
limit is configurable, but you typically must build enough
filtering into your application so that you do not reach the
limit.
Access uses OLEDB to communicate with SQL Server. To provide the
Jet-like cursor behavior desired for desktop applications, Access
implements the Client Data Manager (CDM) as an additional layer
between Access and OLEDB.
Because of the layers required to get from Access to SQL Server in
the ADP architecture, it is often easier to optimize MDB/ACCDB
file solutions. However, there are some scenarios where a report
might be generated significantly faster in an ADP file. To add
these performance improvements and retain the flexibility of SQL
Server, you can build the majority of the application in an MDB or
ACCDB file and have the file load reports from a referenced ADP
file.
One advantage that ADP files have over files in MDB or ACCDB
format is the ability to make design changes to SQL Server
objects. ADP files include graphical designers for tables, views,
stored procedures, functions, and database diagrams.
That clearly shows that MS is deprecating ADPs, not MDBs.
Now, as data stores, the ACCDB is a near cousing of the MDB, because
the new ACE database engine is a fork from the Jet database engine.
It's a different name, but it's really just Jet with a different set
of letters for the file format.
> Will
> Microsoft release a next Access version?
It's already in the works.
> Or will they just move to SQL?
You seem to be confused. Access and SQL Server are not comparable,
as Access is a development platform, and SQL Server is a database
server. Jet is the database engine that Access uses natively and it
is not going away at all. It has received new life with Access 2007
-- previously it was in maintenance mode and was not planned for any
updates except for serious bug and security patches. Now with the
ACE version of Jet, it has new life and will continue to be
developed by the Access team.
> If
> not, will they continue supporting DAO and Access related
> technologies?
DAO also has new life with the ACE. It will be interesting to see if
MS corrects the mistakes with ADO and DAO 3.6, where some new
features of Jet 4 were supported only in ADO and not in DAO.
> I have read so many lose fragments. I read that the next version
> of Windows will use a SQL-driven file system, so database
> technology seem to be part of the OS.
The WinFS has been abandoned for the foreseeable future by MS.
The only peripheral effect I see on Access/Jet when MS finally gets
around to a database-driven file system is that Jet 4 will likely no
longer be used as the data store for Windows Active Directory. I
doubt it will have any effect at all on programs like Access, which
needs to run on all versions of Windows and needs to have a very
easy-to-use default database engine.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
|
|
"Tom Wickerath MDB" <tom_wickerath[ at ]hotmail.com> wrote in
news:#7H6oVbnHHA.5052[ at ]TK2MSFTNGP04.phx.gbl:
[Quoted Text] > of course they should listen to me
And you obviously believe that, having polluted your own reputation
beyond retrieval, that the only possible way anyone would listen to
what you say is if they mistakenly think that it is someone credible
saying it, instead of you.
Pathetic.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
|
|
might be worth noting that aaron has resorted to identity theft because his
own name and known alias are banned (depending on news server), so its the
only way left for him get widely posted.
So sad
"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro[ at ]Spameater.orgZERO_SPAM> wrote in
message news:ulGvhTanHHA.3512[ at ]TK2MSFTNGP06.phx.gbl...
[Quoted Text] > Everyone please note that Aaron Kem.pf is attempting to impersonate one of > our regular posters again. Tom would never post such a message. > > HTH. > Gunny > > See http://www.QBuilt.com for all your database needs. > See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. > Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com > http://www.Access.QBuilt.com/html/expert_contributors2.html for contact > info. > > > "Tom Wickerath MDB" <tom_wickerath[ at ]hotmail.com> wrote in message > news:uCY2PpZnHHA.5068[ at ]TK2MSFTNGP05.phx.gbl... >> yes, of course MDB is depecrated >> >> DAO is obsolete, MDB is obsolete >> >> don't listen to anyone else >> >> >> "Nando" <nospam[ at ]no.spam> wrote in message >> news:8ON4i.32971$p47.2715[ at ]bgtnsc04-news.ops.worldnet.att.net... >>> Hi all! I'm quite confused. Is it true that MDB is deprecated? Will >>> Microsoft release a next Access version? Or will they just move to SQL? >>> If not, will they continue supporting DAO and Access related >>> technologies? >>> >>> I have read so many lose fragments. I read that the next version of >>> Windows will use a SQL-driven file system, so database technology seem >>> to be part of the OS. >>> >>> Any replies, or links greatly appreciated. Thanks! >>> >> > >
|
|
Thanks all very much!!! The replies were very helpful.
"Nando" wrote
[Quoted Text] > Hi all! I'm quite confused. Is it true that MDB is deprecated? Will
> Microsoft release a next Access version? Or will they just move to SQL? If
> not, will they continue supporting DAO and Access related technologies?
>
> I have read so many lose fragments. I read that the next version of
> Windows will use a SQL-driven file system, so database technology seem to
> be part of the OS.
>
> Any replies, or links greatly appreciated. Thanks!
|
|
"Aa r o n Ke m p f" <aaron . k e m p f [ at ] g m a i l . c o m> wrote:
[Quoted Text] >How am I lying?
>
>Tony Toews agreed that MDB is depecrated
You are wwisting words again. ACCDB is the new A2007 format.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
|
|
"A a r o n K e m p f" <a a r o n . k e m p f [ at ] g m a i l . c o m>
wrote in news:#9F1p7csHHA.1752[ at ]TK2MSFTNGP05.phx.gbl:
[Quoted Text] > Tony Toews agreed that MDB is depecrated
Cite the MessageID of any post where Tony has made any such
statement.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
|
|
|