Gunner, thanks for the encouragement. I set ANSI on and was able to use the Update command successfully from the command line but was still unable to update using Forms or the Data Browser.
After digging a little deeper, I found that my ID Quotes were set to Null. After setting them to the back quotes ` character all works as planned. Now I'm having fun! Jim Buddemeyer > 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 >
