I am trying to connect an SQL backend to an Access form via code and for some reason the form is never updateable.
I am trying specifically using PostGreSQL, but I tried also with SQL Server and had the exact same problem.
Here is my code:
private sub Form_Load()
Dim conn as new adodb.connection
dim rs as new adodb.recordset
rs.open("select * from table1"),conn, adopenKeySet, adLockOptimistic
The recordset appears and I can navigate through them, but there is no new record navigate button and I can not edit any of the data. Again I have tried this with both PostGreSQL and SQL Server with the same results. I have also tried all the different combinations of cursor and lock types. I have superuser access on the PostGreSQL and trusted connection access on the SQL Server logged in as administrator.
Any thoughts woulod be greatly appreciated.