(Fwd) RE: [GENERAL] PostgreSQL, ODBC, Access (solution for me)

2000-07-25 Thread Joel Burton
> > 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

Re: [GENERAL] PostgreSQL, ODBC, Access

2000-07-24 Thread davidb
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 =