Click here to Skip to main content
15,901,122 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Access Problem - VB Application Pin
Vimalsoft(Pty) Ltd2-Mar-08 21:59
professionalVimalsoft(Pty) Ltd2-Mar-08 21:59 
GeneralRe: Access Problem - VB Application Pin
aaraaayen2-Mar-08 23:00
aaraaayen2-Mar-08 23:00 
GeneralRe: Access Problem - VB Application Pin
Anoop Brijmohun2-Mar-08 23:05
Anoop Brijmohun2-Mar-08 23:05 
GeneralRe: Access Problem - VB Application Pin
aaraaayen2-Mar-08 23:49
aaraaayen2-Mar-08 23:49 
GeneralRe: Access Problem - VB Application Pin
Anoop Brijmohun3-Mar-08 0:15
Anoop Brijmohun3-Mar-08 0:15 
GeneralRe: Access Problem - VB Application Pin
aaraaayen3-Mar-08 1:03
aaraaayen3-Mar-08 1:03 
GeneralRe: Access Problem - VB Application Pin
Anoop Brijmohun3-Mar-08 1:31
Anoop Brijmohun3-Mar-08 1:31 
GeneralFastest way to pull data out of MS Access DB Pin
Jan Sommer2-Mar-08 20:48
Jan Sommer2-Mar-08 20:48 
Currently i'm pulling out data by using this code:

odCommand = New OleDbCommand("select top 5000 * from TPers, TComp where tpers.compkey = tcomp.compkey", odConnection)
        odReader = odCommand.ExecuteReader
        While odReader.Read
            InsertDBIndexData(odReader("persid").ToString, odReader("cpr").ToString, odReader("firstname").ToString & " " & odReader("lastname").ToString, odReader("legalname").ToString, odReader("tpers.address1").ToString)
        End While
        odReader.Close()


this takes 5 minutes and 5000 people is indexed in my LuceneDB. But the AccessDB contains more than 100.000 people, so the faster the better. I also tried to index the whole DB, but with this code it's never finished. Don't know why.

What's the fastest and best way to pull data from an AccessDB?
GeneralRe: Fastest way to pull data out of MS Access DB Pin
Christian Graus2-Mar-08 22:38
protectorChristian Graus2-Mar-08 22:38 
GeneralRe: Fastest way to pull data out of MS Access DB Pin
Jan Sommer2-Mar-08 23:34
Jan Sommer2-Mar-08 23:34 
GeneralRe: Fastest way to pull data out of MS Access DB Pin
Dave Kreskowiak3-Mar-08 4:29
mveDave Kreskowiak3-Mar-08 4:29 
GeneralRe: Fastest way to pull data out of MS Access DB Pin
Jan Sommer3-Mar-08 21:11
Jan Sommer3-Mar-08 21:11 
GeneralRe: Fastest way to pull data out of MS Access DB Pin
Dave Kreskowiak4-Mar-08 1:34
mveDave Kreskowiak4-Mar-08 1:34 
GeneralRe: Fastest way to pull data out of MS Access DB Pin
Jan Sommer4-Mar-08 6:54
Jan Sommer4-Mar-08 6:54 
QuestionStoring and viewing outlook msg from MS Access Pin
bhagdya2-Mar-08 19:35
bhagdya2-Mar-08 19:35 
GeneralDateTime Picker Help Pin
AAGTHosting2-Mar-08 19:14
AAGTHosting2-Mar-08 19:14 
GeneralRe: DateTime Picker Help Pin
Rupesh Kumar Swami2-Mar-08 19:41
Rupesh Kumar Swami2-Mar-08 19:41 
GeneralRe: DateTime Picker Help Pin
AAGTHosting3-Mar-08 14:06
AAGTHosting3-Mar-08 14:06 
GeneralRe: DateTime Picker Help Pin
Rupesh Kumar Swami3-Mar-08 19:36
Rupesh Kumar Swami3-Mar-08 19:36 
GeneralRe: DateTime Picker Help Pin
AAGTHosting3-Mar-08 19:40
AAGTHosting3-Mar-08 19:40 
GeneralRe: DateTime Picker Help Pin
Rupesh Kumar Swami3-Mar-08 21:32
Rupesh Kumar Swami3-Mar-08 21:32 
GeneralRe: DateTime Picker Help Pin
AAGTHosting4-Mar-08 9:14
AAGTHosting4-Mar-08 9:14 
GeneralRe: DateTime Picker Help Pin
Rupesh Kumar Swami4-Mar-08 19:14
Rupesh Kumar Swami4-Mar-08 19:14 
GeneralShape controls problem at runtime from powerpacks Pin
VB 8.02-Mar-08 19:06
VB 8.02-Mar-08 19:06 
GeneralRe: Shape controls problem at runtime from powerpacks Pin
Dave Kreskowiak3-Mar-08 4:23
mveDave Kreskowiak3-Mar-08 4:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.