No controls are data-bound. No grids etc. I do have a couple of list boxes that I put info into manually but that doesn't happen till later in the game. I checked those and they are not data bound as far as I can tell.
Originally Posted by si_the_geek
I do it all with ADO.
This is how I mount the DB:
I've searched the code and there are no references to bookmarks in the code.
Set rs = New ADODB.Recordset
DE.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & App.Path & DBName
rs.Open "Lines", DE, , adLockOptimistic
If I throw ?rs.bookmarks into the immediate window I get the message:Run-time error 3251
Current Recordset does not support bookmarks.
The weird thing is that this app has worked flawlessly for years and I haven't made any changes recently to the code so I don't understand why it just started to do this.
Another thing that doesn't make sense is that after the app opens the DB it clears it by walking thru the records and deleting each one before it starts to fill it back up.
and that goes just fine.
If rs.EOF <> True And rs.BOF <> True Then
Do While rs.EOF = False
rs.Delete 'clear the lines DB.
It's on that first movenext after filling the first record that the error occurs.