I tried another very simple table. Using a form I cannot update the table Using SSQL I can.
If I connect with a DSN rather than DSNLESS I have no trouble. If you are connecting DSNLESS can you show me your connection string? Perhaps I am missing something. 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 3:27 PM To: RBASE-L Mailing List 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 [email protected]<mailto:[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 [email protected]<mailto:[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]
