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]
