I have set up an MS Access database and am trying to insert records using Ultradev's Insert behaviour. I get the following error....Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.


I can read from the database just fine, any help would be appreciated.

Thanks
Anita.

Where is the database? Local?
Mine was on a service provider.
I had to switch to a different provider.
The database has to be characterized with read AND write permissions.

I hope this helps.

Steven Levy, 781-771-2779,

Actually, yes, that does help <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

I ditched Udev and wrote a simple insert by hand, got a friendlier message this time...

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

Not knowing an aweful lot about MS Access, I trawled through the security settings, and all are open to allow writing, so I'm guessing it's my hosting server that's blocking <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Thanks for the info, at least I know it's not me <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Anita.

Check out your IUSR_machinename (machine name being the actual name of your machine) permission.

Set this permission on the database to full control. I had the same problem as you and this fixed it.

Hope this helps!

www.k.abbott.btinternet.co.uk/

I create a record set without the id.
When I go to live object/insert/ update form I have a problem. I select id as the unique column. It is the unique column. Yet I get a response: "Select a unique column". The message goes away if I select another field, which many not be unique.

Steven Levy,