Harry Broomhall wrote:
> Hiroshi Inoue writes:
> [Charset iso-2022-jp unsupported, filtering to ASCII...]
>>
>> Please try to turn off the *Updatable cursors* DSN option.
>
> Thank you for your quick response.
>
> I have tried your suggestion with no success! :-(
>
> The problem is as before.
>
> (Note - I tried previously to reply, but the 'From:' header line
> wasn't set for the list, and the remote mailer had some error.)
>
> Regards,
> Harry.
>
So that MS Access can auto work out which field to use as a key I first of all create a view as a table with primary key and then create a select rule. A similar thing may stop Excel trying to choose oid as primary key. This is assuming that you've already made sure that its not showing the OID column and isn't set to use it as a fake index.
hth,
- Stuart
DISCLAIMER:The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you.