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]]