Back End Table with Index

[MIKElaw]

Table: Products with ProductID (Integer) as Primary Key and
ProductRef (Text) as Non Unique Index

With rstProd
'Check if its a new product
rstProd.Index = &quot;ProductRef&quot; <--------
.Seek &quot;=&quot;, varIn8

<-------- Failure
If Products is in back end. Move it to Front End and all is well.
Anyone any ideas??

 

[MichaelRed]

Seek only applicable to tables instantiated within the opne database(s). If you ues &quot;linked&quot; tables, they are not part of the database, but simply 'attachments'. To use Seek, you MUST define (DIM) and instantiate (SET) the datbase AND the 'table' type recordset.

This is all plainly documented int he help screens supplied w/ Ms. Access, at least as far back as ver 2.0. While the language may not be conversational english, it is well worth the time and effort to understand the 'manuals', as they will usually provide the unformation you are seeking faster than posting questions and 'hoping' somone will provide a (correct) response. I do not mind responding, just pointing out that many questions are answered more quickly from the Help system than bullitin boards.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over