dbOpenDynaSet and "Seek" Method

[sambo]

I recently split my database and found that I could no longer use the dbOpenTable constant in my code.
So now I have to use dbOpenDynaset instead. The only problem is that I would like to use the "Seek" method, which only works for Recordsets of type dbOpenTable. Any suggestions?

Can someone point me to the knowledge base article dealing w/ differences between these two constants. They are becoming a "constant" thorn in my side and I would like to resolve the issue. (No pun intended...)

 

[jjturner]

I just ran into the same problem during post-split testing on my most recent project.

I converted the 'Seek' method and associated code to the 'FindFirst' method.

Also, if you're using form RecordSources to get any of your recordsets, the Bookmark property of the RecordsetClone is extremely efficient, if not more so than the 'Seek' method.

Regards,
John

 

[sambo]

Thanks jjt-

And for those stubborn folk like me, here is the kb article to workaround.

210266