Re: read/write loop MS Access
- From: "Michel Posseth [MCP]" <MSDN@xxxxxxxxxxx>
- Date: Mon, 19 Feb 2007 07:23:13 +0100
(not part of the MSDN TOC anymore (why?))
Maybe because Access has been declared obsolete as DB backend for
applications for a while
regards
Michel
"Armin Zingler" <az.nospam@xxxxxxxxxx> schreef in bericht
news:eE3$Ca8UHHA.972@xxxxxxxxxxxxxxxxxxxxxxx
"kevin" <kevsout-N0Spam-@xxxxxxxxx> schrieb
Hi,
Hope you can help - I can't see the wood for the trees any more.
I currently have a local MS Access file.
I'd like to do this in VB.NET:
connect to file (select * from table)
for each row in table
if TEST(row) then
remove row
else
increment a field
end if
end for
The success/failure of the TEST function is only partly dependent of
the row's contents (so we can't use the SQL UPDATE command). The MDB
file may contain thousands of rows (so, I'd like to avoid reading it
all into memory at once)
Can someone please point me in the right direction?
Don't know what exactly the problem is, so this is a good place to start:
http://msdn2.microsoft.com/en-us/library/e80y5yhx.aspx
http://msdn2.microsoft.com/en-us/library/ms254937.aspx
http://msdn2.microsoft.com/en-us/library/ms254950.aspx
(not part of the MSDN TOC anymore (why?))
Further, language unrelated and ADO.Net related question fit best here:
microsoft.public.dotnet.framework.adonet
Armin
.
- Follow-Ups:
- Re: read/write loop MS Access
- From: kevin
- Re: read/write loop MS Access
- From: Armin Zingler
- Re: read/write loop MS Access
- References:
- read/write loop MS Access
- From: kevin
- Re: read/write loop MS Access
- From: Armin Zingler
- read/write loop MS Access
- Prev by Date: How to get mousedownevent for form covered with activex controls?
- Next by Date: Re: String Replace/Registry Manipulation
- Previous by thread: Re: read/write loop MS Access
- Next by thread: Re: read/write loop MS Access
- Index(es):
Relevant Pages
|
