I know access fields won't accept nulls unless you specifically set the field to accept them in the field properties. Not saying that is the issue, but the error that happens may not come through the sql API in a meaningful way either.
----- Original Message ----- From: "Javier Valencia" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, June 13, 2011 4:26 PM Subject: [RBASE-L] - RE: DSNLess connection to Access : Dennis, : : It sounds like you are editing the SATTACHed table directly. I just tried : the following: : : SCONNECTed to an Access database : SATTACHed a table : Edited the attached table using the browser : Reopened the table with browser and verified the changes : SDETACHED the table : SDISCONNECTed : : SCONNECTed again : SATTACHed the same table : BROWSED the data and the changes are there. : : Maybe there is a constraint within the Access database that is preventing : you from editing??? : : Javier, : : Javier Valencia, PE : 913-829-0888 Office : 913-915-3137 Cell : 913-649-2904 Fax : <mailto:[email protected]> [email protected] : : _____ : : From: [email protected] [mailto:[email protected]] On Behalf Of Dennis : McGrath : Sent: Monday, June 13, 2011 2:24 PM : To: RBASE-L Mailing List : Subject: [RBASE-L] - RE: DSNLess connection to Access : : Thanks, Javier. : : Unfortunately this won't help me as this little app is using RBASE as the : front end to update the Access database. : : I can read data just fine, just can't update it. : : I'd sure hate to have to rewrite using SSQL to get the job done. : : : Dennis McGrath : Software Developer : QMI Security Solutions : 1661 Glenlake Ave : Itasca IL 60143 : 630-980-8461 : [email protected] : _____ : : From: [email protected] [mailto:[email protected]] On Behalf Of Javier : Valencia : Sent: Monday, June 13, 2011 1:47 PM : To: RBASE-L Mailing List : Subject: [RBASE-L] - RE: DSNLess connection to Access : : Dennis, : : I am working with an Access/SQL Express application, and here is a snippet : of code I use to transfer data to my test database from a remote location: : : ===== : SDETACH ALL EXCEPT AVehicle : : SET ERROR MESSAGES 2038 OFF : DROP TABLE TMainTrans : DROP TABLE TempTrans : SET ERROR MESSAGES 2038 ON : : PAUSE 3 USING 'Connected to Fuel System...' + : CAPTION 'Attaching Transactions Table in Progress...' ICON WARNING : : SATTACH TEMPORARY 'MainTrans' AS TMainTrans USING ALL : PAUSE 2 USING 'Table Attached - Press any key to continue...' + : CAPTION 'Attaching Transactions Table Progress...' ICON WARNING : CLS : : -- Check if the data is available - Optional : BROWSE * from TMainTrans : : PROJECT TEMPORARY TempTrans FROM TMainTrans USING * : : OUT transactions.all : UNLOAD ALL FROM TempTrans : OUT SCREEN : : DROP TABLE TempTrans : : SDETACH ALL EXCEPT AVehicle : . : ===== : Now, I can run the command transactions.all and I get a fully editable : Temporary table. If you want to create a permanent table juts remove the : "TEMPORARY" portion of the PROJECT command. : : I was having some problems before and the procedure above works every time. : I am not sure if this is what you were looking for, but it might give you : some .blues clues.as R;azzak would say. : : Javier, : : Javier Valencia, PE : 913-829-0888 Office : 913-915-3137 Cell : 913-649-2904 Fax : <mailto:[email protected]> [email protected] : : _____ : : From: [email protected] [mailto:[email protected]] On Behalf Of Dennis : McGrath : Sent: Monday, June 13, 2011 1:13 PM : To: RBASE-L Mailing List : Subject: [RBASE-L] - RE: DSNLess connection to Access : : Correction, I see the error on the screen after I leave the form. : The driver is complaining that I am trying to update ScoreID which is the : primary key. : That column in not on the form anywhere. : I get the same error if I try at the R> prompt. : : Dennis McGrath : Software Developer : QMI Security Solutions : 1661 Glenlake Ave : Itasca IL 60143 : 630-980-8461 : [email protected] : _____ : : From: [email protected] [mailto:[email protected]] On Behalf Of Dennis : McGrath : Sent: Monday, June 13, 2011 1:04 PM : To: RBASE-L Mailing List : Subject: [RBASE-L] - DSNLess connection to Access : : Has anyone seen this issue. : : I used a DSN to connect to an Access DB : Everything works great. : : Unloaded the structure of the RBASE Db and extracted the part of the file : that did the sATTACH commands. : I used this to reattach (after SDETACH ALL) with a dsnless connection. : I cannot edit the data. If I try an edit from the R> I get error messages. : If I edit using a form, I get no error but the data will not stick. : : : Dennis McGrath : Software Developer : QMI Security Solutions : 1661 Glenlake Ave : Itasca IL 60143 : 630-980-8461 : [email protected] : :
