• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

why do i get this error?

i'm opening a recordset - and i get teh following:

Error number: -2147467259
description: Not a valid bookmark.

i'm using ado with jet 4 to access an MS Access database.

my connection string:  

Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=F:\sosbinary\DBCONFIG.MDB;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False
1 Solution
where exactly in your code do you get the error? can you post the code here?
kenshawAuthor Commented:
on this line:

Set rs = Conn.Execute("select * from tbl_errorlog where tusername='" & getusername & "' and ierrortype=10 and bIsactive=true order by dlogtime")
Generally this error message shows that there are damaged data records. A very faulty network can be the cause. Look out! Do not continue to work on the network, because the database is extremely endangered or possibly already damaged! Copy (e.g., with the help of the clipboard) the "healthy" data records into a new table avoiding touching the damaged records.
MS Access has an option to repair and compact a database.
Most of the times it will work well...
also it is always good to do a compact after deleting records
(deleting records will not free the space in the database!)

In vb are these commands also available:

How do you provide getusername with a value?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now