Tuesday 19 December 2017

Fixes To Resolve MS Access “Not A Valid Bookmark” Error



Scenario:

Hey friends…!
 Few days back when I tried to open the Access Database, I receive the following error message "Not a Valid Bookmark" and all of a sudden my database denies opening. I have tried Compact and Repair but it won’t help me in resolving this error. I created new DB and tried to import from corrupted DB but still got the same error message. I tried accessing the DB using access and ms query and still won’t get any success. 


I searched a lot and finally got the fixes to resolve this specific Not A Valid Bookmark Error. Here in this blog I have shared the fixes that I have tried to resolve this error. So, if you too dealing with such an issue then must try the fixes.

About Error 3159 Not a valid bookmark:

The MS Access error “Not a valid bookmark” encounters when working with the Access VBA code, meanwhile the recordset bookmark property gets set with invalid string. Thus the error Not a valid bookmark appears.

Recordset object relies completely on the Microsoft Access database engine tables.  Value of the Bookmarkable property is true and you can use the bookmark property with that recordset. Recordset bookmark property sets to bookmark that uniquely identify the current record in recordset objects. This specific error code occurs when working with the recordset.

Error details:

Error Name : Not a valid bookmark
Error Number: 3159

Here is the screenshot of the error:


Symptom:

Circumstances under which this specific error get prompted to your screen. Here is the most vulnerable reason to this: 

When user bookmark a string which was not saved from previously reading Bookmark Property.
While using ms access to open a corrupted access database file.
Or when the user uses the bookmark property of the recordset objects to bookmark invalid string.
The error also occurs when some data records in your access database are damaged.
Corruption issue encountered in the database relationships.

Resolution To Fix Access “Not A Valid Bookmark Access” Error

Method 1: Reproduce The Error

In order reproduce the access “Not A Valid Bookmark” Error you need to create table, so that in VBA they can be able to create recordset. Tapping to the form button an error 3159 will generated. 

Code to reproduce the error:

Option Compare Database
Private Sub Command0_Click()
Dim rst As Recordset
Dim str As String
'Error 3159 Not a valid bookmark.
Set rst = CurrentDb.OpenRecordset("Table1", dbOpenDynaset)
str = rst(0)
rst.Bookmark = str
End Sub

Resolution:

To resolve this, just save the string after reading a bookmark property. So, for the next time it seems available. Make use of the valid string to accomplish the task successfully.

Try the Access Repair And Recovery Tool

In order to resolve this particular access query error ”Not A Valid Bookmark” you must try out the professional tool i.e Access Repair And Recovery tool. As, this tool is designed with the main prospective of dealing with the ms access database corruption issues.  

Moreover, the software effectively recovers inaccessible MDB and ACCDB files accurately from corrupt or damaged MS Access databases. Easily retrieves OLE data, Memo data, table relationships, and original date format. Restores complete table structure and key internal data structures like primary keys, auto-number and field sizes accurately.

   

1 comment:

  1. this Access File Repair is a smart solution to repair the entire MS Access Database and recover it back. With this tool, you can get corrupt ACCDB file or MDB database files back to a new one.

    ReplyDelete