Forums
This topic is locked
Access and Postgresql
03 Aug 2001 00:53:24 David Fee posted:
I can I successfully configured the ODBC connection linking Postgresql tables to Access 97 and Access 2000. My problem is I can only view the data in the tables. I'd like to edit the data in the tables and the tables themselves. Does anyone know how to do this. Dave
Replies
Replied 10 Aug 2001 22:13:36
10 Aug 2001 22:13:36 Joel Martinez replied:
hmm... I've had this issue in the past with linking SQL server tables... it wouldn't let me update, or delete anything until I set a primary key on the table.
I'm not sure how postgreSQL works, but see if you can specify a primary key when you link the table.
Joel Martinez
----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
I'm not sure how postgreSQL works, but see if you can specify a primary key when you link the table.
Joel Martinez
----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
Replied 11 Aug 2001 21:02:39
11 Aug 2001 21:02:39 Bruno Mairlot replied:
This issue isn't linked with the primary key. It depends on the ODBC driver.
For example MySQL ODBC won't let you do ALTER query.
Actually I'm not sure if it wouldn't let you do ALTER query, but more because Access doesn't know how to do such a thing.
Maybe what you can try to do is using SQL view in access then type the query as a whole, then execute it.
"First they laugh at you, then they fight you, then you Win..." Ghandi
For example MySQL ODBC won't let you do ALTER query.
Actually I'm not sure if it wouldn't let you do ALTER query, but more because Access doesn't know how to do such a thing.
Maybe what you can try to do is using SQL view in access then type the query as a whole, then execute it.
"First they laugh at you, then they fight you, then you Win..." Ghandi