Jim You can! You can create forms and update from there. You can use the update command to update programmatically. You can use insert to add new rows. I have now a planning system in MS ACCESS integrated with an accounting system in R:BASE. What I stumbled on in the beginning was: I started using alias and found out that was not a good idea föor Access. I started with ANSI ON in my case that was not a good idea. I started trying commands like append, change that was not a good idea. You must be very careful not to use old R:BASE syntax stick to strickt SQL
Gunnar Ekblad -----Ursprungligt meddelande----- Från: [email protected] [mailto:[EMAIL PROTECTED] För [EMAIL PROTECTED] Skickat: den 28 oktober 2005 18:15 Till: RBG7-L Mailing List Ämne: [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
