search for: odbcprimarykeys

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

Hi Michael, Here is the result of my first testing: (0) Dr. Watson Sorry, I should have given a more precise description: by default in R exists a function with the name 'table', if you use this name as in odbcPrimaryKeys(0, table) a Dr. Watson occurs, because table does not give a table name. However, it is always a good idea to prevent Dr. Watsons, even if it is triggered by a stupid user, as in my case. (1, may be Davids comment already solves this?) There are still some problems with sqlTables() and sqlQuery(...