Re: Reading Access DB: get someteimes Data - sometimes not
From: Marcel Gätzi (MarcelGtzi_at_discussions.microsoft.com)
Date: 07/28/04
- Next message: Rasmus: "recordset.sort Problems with data types"
- Previous message: Val Mazur: "Re: saving a select stament to a txt file"
- In reply to: Val Mazur: "Re: Reading Access DB: get someteimes Data - sometimes not"
- Next in thread: Val Mazur: "Re: Reading Access DB: get someteimes Data - sometimes not"
- Reply: Val Mazur: "Re: Reading Access DB: get someteimes Data - sometimes not"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Jul 2004 23:13:04 -0700
Hi Val,
I'm glad you don't see anything wrong in my Code. I use the "if rst.BOF ..." line for debuging reasons. You mentioned "MDAC corruption". Can this explain the situation?
I don't get no data on this specific server - it works fine until a certain time, after this I only get EOF and after another while the server crashes. Who can I fix MDAC corruption?
Thank you very much for your help!
Marcel
"Val Mazur" wrote:
> Hi,
>
> I do not see anything wrong in a code, except it could be simpler. If it
> works on all PCs, except one, then it could be related to the MDAC
> corruption. Do you get any error message?
> Your code actually should look like (you do not need to check for BOF and
> EOF in your case and do not need to use MoveNext)
>
> Set rst = cmd.Execute()
>
> If Not rst is Nothing Then
> Do While Not rst.EOF
> '************************* in the beginning, data is retrieved
> Call rst.MoveNext
> Loop
> End If
>
> --
> Val Mazur
> Microsoft MVP
- Next message: Rasmus: "recordset.sort Problems with data types"
- Previous message: Val Mazur: "Re: saving a select stament to a txt file"
- In reply to: Val Mazur: "Re: Reading Access DB: get someteimes Data - sometimes not"
- Next in thread: Val Mazur: "Re: Reading Access DB: get someteimes Data - sometimes not"
- Reply: Val Mazur: "Re: Reading Access DB: get someteimes Data - sometimes not"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
