Access DB Connect

Started by Michael Greer, February 20, 2025, 04:29:09 PM

Previous topic - Next topic

Michael Greer

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 :).

Michael Greer

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.