Hello:

I've been trying to extract some data records from a security enabled Access database using R. Although I seem to have permissions to access the database, R does not appear to be able to read any records. Does anyone have a suggestion or possible solution. Here is the error message:

> source("C:\\stass\\Martell Data\\Dimport.r")
Loading required package: RODBC
> objects()
[1] "Biodata" "channel"
> Biodata
[1] "42000 -1907 [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'agecomp'."
[2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM \"agecomp\"'"                                              
> 

Jake

Jake Schweigert,
Section Head, Conservation Biology
Fisheries and Oceans | Pêches et Océans
Marine Ecosystems and Aquaculture Division | Division des 
écosystèmes marins et de l'aquaculture
Pacific Biological Station | Station de recherché biologique du Pacifique
3190 Hammond Bay Road | 3190 chemin Hammond Bay
Nanaimo, BC   V9T 6N7 | Nanaimo (C.-B.)  V9T 6N7
Telephone | Téléphone   250-756-7203
Facsimile | Télécopieur  250-756-7138






	[[alternative HTML version deleted]]

