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


