Results 1 to 3 of 3
  1. #1
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544

    Question "Not a valid bookmark" error...??????

    I have a database that is on a scheduler. All it does is open up, update a few tables and then closes. I received an inexplicable error this morning so I ran a compact and repair....Fixed my original problem and now I have an even more perplexing problem. On the below code when it tries to execute the line in red I get a Run-time "Invalid bookmark" error . All of the forums I've found that pertain to this have some reference to a bookmark. As you can see I have no reference to a bookmark. Any suggestions?

    Code:
    Function funStoreDistrictRegion()
    'On Error Resume Next
        Dim mySQL As String
        
        mySQL = "DELETE * FROM Store;"
        CurrentDb.Execute mySQL
        
        mySQL = "DELETE * FROM District;"
        CurrentDb.Execute mySQL
    '...Remaining code (Just a few more SQL statements)
    End Function
    I have tried running another compact & repair to no avail.

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Most likely corruption. See this here (read #9)

    http://www.granite.ab.ca/access/corruption/symptoms.htm

  3. #3
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    It was the beginning of corruption...Waiting on a file restore as we speak.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. What does "not a valid bookmark" mean?
    By ejohnso4 in forum Forms
    Replies: 3
    Last Post: 06-05-2014, 08:49 AM
  2. Error: " is not a valid name
    By tonere in forum Access
    Replies: 4
    Last Post: 06-03-2011, 10:39 AM
  3. "Group By" causes "ODBC--Call Failed" error
    By kaledev in forum Queries
    Replies: 1
    Last Post: 03-09-2011, 02:43 PM
  4. Replies: 8
    Last Post: 11-12-2010, 10:55 AM
  5. Move bookmark to "new" record
    By BayerMeister in forum Forms
    Replies: 9
    Last Post: 08-17-2010, 05:16 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums