I tried with DSN-Less and it works correctly; this the connect command:
SCONNECT ';Driver={Microsoft Access Driver
(*.mdb)};DBQ=C:\Syntech\FuelMasterPlus\FuelMasterPlus.mdb;'
This is the attach command:
SATTACH VehicleMake USING ALL
This is the simplest version of the SATTACH command.
I tied connecting, attaching, detaching and disconnecting several times, and
the edit I make are always there.
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 3:48 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: DSNLess connection to Access
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
<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]
