I am using R to access .mdb files (created in Microsoft access 2003) through
RODBC.
I am able to view the Tables and also list their attributes through the
sql............. commands. However, when try to acces the primary keys (using
sqlPrimaryKeys /odbcPrimaryKeys) I get a value of '-1' on my command line,
i.e. I am unable to identify the PrimaryKeys in the Tables.
Any suggestions why this would happen.
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.