How To Resolve MS Access “Not A Valid Bookmark” Error
Are you encountering “Not a Valid Bookmark" error in your access database whenever you try to access the database using query? Well if you are looking for the fixes to resolve this then just go through this post and get all the answers regarding all your queries.
Error 3159 : Not a valid bookmark
Access Not a valid bookmark error usually occurs while working with the MS Access VBA, recordset bookmark property gets set with invalid string.
Recordset object based completely on the Microsoft Access database engine tables. The value of Bookmarkable property is true and you can use the bookmark property with that Recordset. Recordset bookmark property sets or returns bookmarks that uniquely identify the current record in Recordset object. The access error 3159 generally encounters when working with recordsets.
Error Name :
Not a valid bookmark
Error Number: 3159
Here is the screenshot of the error:
Check out the circumstances under which the following “Not a valid bookmark” error get prompted to your screen.
- When user bookmark a string that was not saved from previously reading Bookmark Property.
- When using MS Access to open a corrupted access database file
- While using the bookmark property of recordset objects to bookmark invalid string.
- When there is some corruption issue encountered in the database relationships
Manual fixes for Access “Not A Valid Bookmark Access” Error
Method 1: Reproduce The Error
To reproduce this specific error code “Not A Valid Bookmark Access” you need to create table. So that in VBA they can be able to create recordset. After clicking 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
Just save the string after reading a bookmark property. So, that for the next time it is available. Make use of the valid string to accomplish the task.
Method 2: Access Repair And Recovery Tool
Try the Access Repair And Recovery tool to resolve this Access Query Error Not A Valid Bookmark” error. As, this tool is specifically designed to deal with the Ms Access Database corruption issues. Besides that the software effectively recovers inaccessible MDB and ACCDB files accurately from corrupt or damaged MS Access databases.