Mega Code Archive

 

Categories / Delphi / ADO Database

 

Problems with ms access

Question: I'm having trouble with using BDE 3.5 to talk to a Microsoft Access table. Specifically, if the table has a primary key, and I create a secondary key which uses one of the fields in the primary key, my C++ program no longer recognizes the primary key. What do I need to do? Answer: You need to have a secondary key which uses the _first record_ in the primary key. It is not necessary that all secondary keys do this, just that one of them does.