var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DAO - Finding the Index\Primary Field?
Hi there, im using VB6 with Data Access Objects connecting to an Access 2000 database.
I would like to find what the index\primary key is from the database using the DAO, but cannot find a method or property with the RecordSet object to do so.
Any help much appreciated
Re: DAO - Finding the Index\Primary Field?
in MS Access you can use
For i = 0 To CurrentDb.TableDefs('mytable').Indexes.Count - 1
Debug.Print CurrentDb.TableDefs('mytable').Indexes(i).Name & " : "; CurrentDb.TableDefs('mytable').Indexes(i).Primary
if you use VB, you have to call DAO... it has the same property, there are few samples in DAO help...