You are correct. No I hadn't. In fact, at your prompting, I had to do a bit of poking around find it. Sure enough the index dialouge showed the name as "UniqueID", most likely a leftover artifact from my attempted debug efforts or perhaps even a default name.
As I originally suspected it was...
With experimentation, it has been both and consistantly
got the error.
It currently is not the primary key.
Indexed - Yes(no duplicates)
I would not think the index property of a recordset would object to being a primary key, but perhaps so.
Currently, it is just an indexed field in TocTable...
I started with the code from trusty ol' microsoft kb article 210269
http://support.microsoft.com/?kbid=210269
Looks pretty straight forward and very much needed in this case.
Put in the code with the appropriate changes.
Try to run it and get:
Run-time error '3800':
'IndexEntry' is not an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.