search for: sqlprimarykey

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

Dear all, I need to test for the existence of an index on a table. This cannot be done with sqlPrimaryKeys as it is not a primary key. Therefore I select directly from the systemtable of SQL-Server 2000 named sysindexes. This works well with RODBC Version 1.2-5 but not with version 1.3-0. Here is the code of the test example: sink(file = "proto.txt", append = FALSE, type = "output&quot...