I have to connect to a couple of MS Access databases and I have a problem
with one of them.
The following code works for a database with Access 2000 file format:
>>>>>
-- The following lines come from a working application with Access 2000 file
format
SDETACH ALL NOCHK
SDISCONNECT ';Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Program
Files\VB6 WTCost 2-5-05\WTData2000.mdb;'
SCONNECT ';Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Program Files\VB6
WTCost 2-5-05\WTData2000.mdb;'
-- Get Data From scenario Description - 47 columns
SATTACH 'Scenario Description' AS WT_SD USING ALL +
ALIAS
SDCol1,SDCol2,SDCol3,SDCol4,SDCol5,SDCol6,SDCol7,SDCol8,SDCol9,SDCol10,+
SDCol11,SDCol12,SDCol13,SDCol14,SDCol15,SDCol16,SDCol17,SDCol18,SDCol19,SDCo
l20,+
SDCol21,SDCol22,SDCol23,SDCol24,SDCol25,SDCol26,SDCol27,SDCol28,SDCol29,SDCo
l30,+
SDCol31,SDCol32,SDCol33,SDCol34,SDCol35,SDCol36,SDCol37,SDCol38,SDCol39,SDCo
l40,+
SDCol41,SDCol42,SDCol43,SDCol44,SDCol45,SDCol46,SDCol47
-- The following line displays the data correctly
BROWSE * FROM WT_SD
DROP TABLE WT_SD
SDETACH ALL NOCHK
SDISCONNECT ';Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Program
Files\VB6 WTCost 2-5-05\WTData2000.mdb DB;'
<<<<<
The following code DOES NOT work for a database with Access 2002-2003 file
format:
>>>>>>
SDETACH ALL NOCHK
SDISCONNECT ';Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Program
Files\AWS\Interact\LMSDATAA.MDB;'
SCONNECT ';Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Program
Files\AWS\Interact\LMSDATAA.MDB;'
-- No error to this point
-- Get Data From TransactionTable - 65 columns
SATTACH 'TransactionTable' AS WT_SD USING ALL +
ALIAS
SDCol1,SDCol2,SDCol3,SDCol4,SDCol5,SDCol6,SDCol7,SDCol8,SDCol9,SDCol10,+
SDCol11,SDCol12,SDCol13,SDCol14,SDCol15,SDCol16,SDCol17,SDCol18,SDCol19,SDCo
l20,+
SDCol21,SDCol22,SDCol23,SDCol24,SDCol25,SDCol26,SDCol27,SDCol28,SDCol29,SDCo
l30,+
SDCol31,SDCol32,SDCol33,SDCol34,SDCol35,SDCol36,SDCol37,SDCol38,SDCol39,SDCo
l40,+
SDCol41,SDCol42,SDCol43,SDCol44,SDCol45,SDCol46,SDCol47,SDCol48,SDCol49,SDCo
l50,+
SDCol51,SDCol52,SDCol53,SDCol54,SDCol55,SDCol56,SDCol57,SDCol58,SDCol59,SDCo
l60,+
SDCol61,SDCol62,SDCol63,SDCol64,SDCol65
After the command above I get the following error at the R> Prompt screen
when running with Messages ON, Error Messages ON and ECHO ON.
--ERROR- Error message from server: [Microsoft][ODBC Microsoft Access
Driver] Record(s) cannot be read; no read permission on 'TransactionTable'.
(2957)
I can double click on either of the databases from the Windows Explorer and
they will open correctly (with Access) and do not seem to require and
login/password.
Is there a different way to connect to Access databases with the 2002-2003
file format? Is there a setting that needs to be tweaked in Access...or
R:Base?
Javier,
Javier Valencia
913-915-3137
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of R:BASE
Training
Sent: Thursday, October 30, 2008 1:40 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - R:BASE University Schedule Update
October 30, 2008
Dear R:BASE Community,
Due to popular demand, the R:BASE University schedule
has been updated with additional dates for the R:BASE
7.6/Turbo V-8 Super Advanced Training and for a new
class, the R:WEB Suite 4.0/8.0 Boot Camp.
The scheduled Training Events are now posted on the
Events Page:
http://www.rbase.com/events/
For the first time, R:BASE University is squeezing in
the R:WEB Suite Training immediately following the
R:BASE SAT. The evening class will be a warm-up session
to install, configure, and setup R:WEB Suite, R:WEB
Reports, and R:WEB Gateway. The following day will
cover designing, testing, and deploying your R:WEB
Suite project(s).
R:BASE 7.6/Turbo V-8 Super Advanced Training Details
----------------------------------------------------
Training Style: Lecture (all attendees should bring
their notebook computers with R:BASE 7.6/Turbo V-8
already installed)
Days: 2
Time: 9:00 AM - 5:00 PM
R:WEB Suite 4.0/8.0 Boot Camp Details
----------------------------------------------------
Training Style: Lecture (all attendees should bring
their notebook computers with R:WEB Suite 4.0/8.0
already installed)
Days: 1.5
Time Day 1: 6:00 PM - 10:00 PM
(covers installation, configuration, and setup)
Time Day 2: 9:00 AM - 5:00 PM
(covers design, test, and deploy)
For Training locations, pricing, and other details,
please visit:
http://www.rbaseuniversity.com <http://www.rbaseuniversity.com/>
For Reservations:
Phone: 1+724.733.0053
E-Mail: mailto:[EMAIL PROTECTED]
Success in business requires training, discipline and
hard work. - David Rockefeller
Best regards,
Training Services
R:BASE Technologies, Inc.
http://www.rbase.com <http://www.rbase.com/>
[EMAIL PROTECTED]
Phone: 1+724.733.0053
