Not a valid bookmark! 2

[kpryan]

Hi all you gurus,
This error came up on our database. Fortunately I had a backup
so no problems. Could not even compact or repair. What causes this error.

Many thanks,

Ken

 

[TheAceMan1]

How are ya kpryan . . .

When a form is opened & loaded, each record is asigned a [blue]BookMark[/blue] value. Also each time the form is opened, the bookmarks are never the same.

One way to goto a record is by manipulating the bookmark property of a form or recordset. [blue]The error is raised when the bookmark property assigned doesn't exits[/blue] . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[kpryan]

Hi The Aceman1,

many thanks for your help.
Is this the forum to explain the latter part of you reply.. 'bookmark property does not exist.' How does this occur?
Or can you point me in the right direction to be able to follow this up.

Many thanks,

Ken

 

[MajP]

1) You may have some code that references the bookmark property for an object that does not have a bookmark property. So search your code for the word "bookmark" and post any code that references it.
2)Compile your code and see if it breaks any where
3)If not 1 or 2 then your database may be corrupted which can be caused by many things. Network, poor database design, access quirkiness:

http://support.microsoft.com/kb/300216

http://articles.techrepublic.com.com/5100-10878_11-1060083.html

 

[TheAceMan1]

[blue] . . . 'bookmark property does not exist.' [purple]How does this occur?[/purple][/blue]

Almost invariably this occurs with recordsets. Consider for a form you perform the following:

[blue]   Dim rst As DAO.Recordset
   
   Set rst = Me.RecordsetClone[/blue]

Here the recordset bookmarks are a copy of the form bookmarks, so that:

[blue]   Me.Bookmark = rst.Bookmark[/blue]

Always works. However, if while both form and rst are active you requery either the form or recordset, the requeried object is assigned a different set of bookmarks. A miss match now exists.

Consider the above when you hold a bookmark for return to a record after requery!

Actually this idea of bookmarks as it relates to your problem is quite academic, as [purple]I'd expect you to get this error during design testing! This is an hardcore error that will always raise its head![/purple]

Since the Db was working and as you say . . .

[blue]Could not even compact or repair.[/blue]

. . . along with . . .

[blue]3)If not 1 or 2 then your [purple]database may be corrupted[/purple] which can be caused by many things.[/blue]

. . . [PURPLE]Corruption[/purple] appears to be more the hardcore problem than any bookmark!

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886