why do i get this error?

Posted on 2005-05-10
Last Modified: 2008-02-07
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
Question by:kenshaw
    LVL 39

    Expert Comment

    where exactly in your code do you get the error? can you post the code here?
    LVL 4

    Author Comment

    on this line:

    Set rs = Conn.Execute("select * from tbl_errorlog where tusername='" & getusername & "' and ierrortype=10 and bIsactive=true order by dlogtime")
    LVL 7

    Accepted Solution

    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.
    LVL 7

    Expert Comment

    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:

    LVL 44

    Expert Comment

    How do you provide getusername with a value?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now