Re: FN-FORUM Access SQL Error

date posted 31st January 2001 10:33

>Anybody got any idea what this means...
>
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>[Microsoft][ODBC Microsoft Access Driver] Operation must use an
>updateable query.
Mark,

THis is just a wild guess, but when Access2000 first came out I remember
seeing quite a few queries on various forums about records failing to
update correctly, where they had worked fine in earlier versions. The
solution was that tables had to contain both a unique ID field AND a
timestamp field to avoid insert and update errors.

As I say, its just a guess, but it might be worth a try?

Ray McGinty

=======================================================
Ray McGinty Information Design
specialising in design for the web, e-commerce,
multimedia CD-ROM and print
Tel 0191 237 2816
Fax 0191 237 4774
[EMAIL REMOVED]
www.rmid.co.uk
=======================================================