RE: using New ADODB.Recordset to Find

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jim Shores (JimShores_at_discussions.microsoft.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 10:37:01 -0700

that could be it, I was just pessimistic, however,
  I made up this different .mdb to keep my automatic stuff in and it is from there I am connecting to my main db. Appreciate it, I'll try the adjustment. 

-- 
Jimbo  
"JimB" wrote:
> Jim,
> 
> You are opening the table, running some code then closing 
> the table.  Is the forms data source the same table you 
> are trying to open?  I use ADODB to open tables like this:
> 
> Dim ccn As New ADODB.Connection
> Dim rst1 As New ADODB.Recordset
> Set ccn = CurrentProject.Connection
> 
> rst1.Open "yourtablename", ccn, adOpenKeyset, 
> adLockOptimistic
>  code.........
>  code..........
> rst1.Close
> 
> rst1 = Nothing
> 
> 
> >-----Original Message-----
> >pray tell why when 
> >in a form Open event to get some stuff I go
> >--
> > . . .
> >rst1.Open "tblInfo", , adOpenKeyset, adLockPessimistic, _
> >    adCmdTable
> >.. . . then
> >rst1.Close
> >Set rst1 = Nothing
> > . . .
> >
> >sometimes my form doesn't make it open and I see msg 
> >'runtime -2147467259(80004005) db placed in a state . . .
> >prevent being opened or looked at' 
> >					?
> >-- 
> >Jim Shores on Red Mountain 
> >    in Birmingham, Alabama
> >.
> >
>