I have an Access DSN (user, I would love to know if anyone has successfully set up an Access System DSN). This open works:
0220 open (hfn,iol=*,err=9010)"[ODB]TearDownLive;ReceiptTable;key=CoreItemCheckDigit"; in=lfo
But this throws an error 80 - Invalid key definition, number or name.
0220 open (hfn,iol=*,err=9010)"[ODB]TearDownLive;OutInventTable;key=CoreItemCheckDigit"; in=lfo
The person who developed the access tables says they are the same. Any insight here would be appreciated. This was supposed to be the easy part :).
Ok. I was able to access the design view for the table in question *and* the one that worked. The one failing had a lookup defined. When I had the Access developer remove that lookup I was able to get a good open. Thought others might like to know.