Re: ODBC read/write permission in MS Access

On Tue, 31 Jul 2001 wsheldah(at)lexmark(dot)com wrote:

>
>
> Check to see that the user you specified in the Windows DSN has all the
> permissions in PostgreSQL it should have to do the updates. Is Access telling
> you that you have a non-updatable recordset? If so, I think the online help has
> a set of troubleshooting steps to work through.
>
> Long term, you might consider using unbound forms that use select statements to
> fill out the form in its On Load event, and insert/update statements to update
> the back end on the appropriate On Update, etc. events. Locks won't be held as
> long, you'll get to do programmatic error checking and error handling which
> could make it more user-friendly, etc. etc.

or search google or the archives for "half-bound" forms, where I explain
strong compromise to bound/unbound forms.

--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington