[R] RODBC Access limit?

[ONKELINX, Thierry]

Have you checked your data at row 3277? It could be that there is
something odd in that row.

HTH,

Thierry


------------------------------------------------------------------------
----
ir. Thierry Onkelinx
Instituut voor natuur- en bosonderzoek / Research Institute for Nature
and Forest
Cel biometrie, methodologie en kwaliteitszorg / Section biometrics,
methodology and quality assurance
Gaverstraat 4
9500 Geraardsbergen
Belgium 
tel. + 32 54/436 185
Thierry.Onkelinx op inbo.be 
www.inbo.be 

To call in the statistician after the experiment is done may be no more
than asking him to perform a post-mortem examination: he may be able to
say what the experiment died of.
~ Sir Ronald Aylmer Fisher

The plural of anecdote is not data.
~ Roger Brinner

The combination of some data and an aching desire for an answer does not
ensure that a reasonable answer can be extracted from a given body of
data.
~ John Tukey

-----Oorspronkelijk bericht-----
Van: r-help-bounces op r-project.org [mailto:r-help-bounces op r-project.org]
Namens HBaize
Verzonden: donderdag 3 juli 2008 9:37
Aan: r-help op r-project.org
Onderwerp: [R] RODBC Access limit?



I have been using RODBC to connect to an Access database to capture data
to
create plots. Recently I found incomplete charts. Upon investigation I
discovered that the data retrieved stopped at 3276 rows (records) out of
a
table with over 5600 records. 

I've tried changing "max","buffsize", and "rows_at_time" but it still
returns only 3276 rows.  

Is this a limitation in R or Access? Is there an easy work around? 

Thanks for any helpful suggestions.







-- 
View this message in context:
http://www.nabble.com/RODBC-Access-limit--tp18253443p18253443.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help op r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.