> > Here's a bothersome issue: I've got the most recent versions of
> > Postgres, ODBC client for Win32, and Access 97. My client can
enter
> > new records fine via a linked table. However, when she goes
back to
> > add data to a column, she gets the following error:
> >
> > message box title
Hi Jeffrey,
If you open a form that is bound to a table (or bound to a query that is
bound to a table) that is one database connection. If you then script
database updates from the form
(e.g.:
Dim dbs As Database
Set dbs=CurrentDB
dbs.Execute("UPDATE tbl_blah SET szBlah = 'blah' WHERE nBlahID =