Make sure you have a primary key defined on each table you want to update. Troy
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, October 28, 2005 10:15 AM To: RBG7-L Mailing List Subject: [RBG7-L] - ODBC and MS Access Wouldn't the world be simpler if everyone used R:base. I'm trying to use R:base (because I can, I think?) to manipulate data in a canned MS Access database. I can SConnect and Sattach to the database and tables. My problem is that I can not update the Access tables. I created a simple Access database with the same results. Is it possible to update MS Access tables with R:base? Do I need to do something other than defining a System DNS? (Using MS Access OBDC driver 4.00.6019.00 dated 08/22/2002) Jim Buddemeyer
