Meant to add this:
While Access is great for getting at DBF files, it will not
maintain the
DBF's indexes.
-----Original Message-----
From: Discussion of writing applications and components
using Visual
Basic .NET [mailto:VBDOTNET DISCUSS.DEVELOP.COM] On
Behalf Of Stacey
Levine
Sent: Tuesday, November 21, 2006 3:28 PM
To: VBDOTNET DISCUSS.DEVELOP.COM
Subject: Re: [VBDOTNET] suggestions for accessing DBASE III
files
You are correct. That is exactly what I am looking for. I
have found one
product by Vista Software, but it doesn't look like it has
been updated
in 3 years and that makes me a little wary. I am looking
for some type
of native .NET DBASE data provider
Thanks.
Stacey
-----Original Message-----
From: Discussion of writing applications and components
using Visual
Basic .NET [mailto:VBDOTNET DISCUSS.DEVELOP.COM] On
Behalf Of Stuart
Laughlin
Sent: Tuesday, November 21, 2006 3:11 PM
To: VBDOTNET DISCUSS.DEVELOP.COM
Subject: Re: [VBDOTNET] suggestions for accessing DBASE III
files
On 11/21/06, Stacey Levine <staceyl musicforasong.com>
wrote:
>
>
> My application currently accesses those files through a
linked table
in
> MS Access and I am looking for a way to speed this up.
If by 'this' you mean the database connectivity between
Access and
DBase,
I'm skeptical that you will succeed in your attempt to speed
it up.
Presumably Access is using OLE DB or ODBC to access DBase.
.NET will use
those same technologies, unless you can find a DBase .NET
Data Provider
that
accesses DBase 'natively'. There may be such a thing; I
don't know
anything
about that.
My point is simply that the standard way of interacting with
'legacy'
databases is via OLE DB or ODBC. I presume that is what
Access is using,
and
I presume that is the approach you would take via .NET. If
so, then in
both
cases you are dealing with the same technology/speed
limitations; in
...NET
you just get a pretty wrapper.
HTH,
--Stuart
===================================
This list is hosted by DevelopMentor(r) http://www.develop.com
View archives and manage your subscription(s) at
http://discuss.develop.com
===================================
This list is hosted by DevelopMentor(r) http://www.develop.com
View archives and manage your subscription(s) at
http://discuss.develop.com
===================================
This list is hosted by DevelopMentorŪ http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
|