Insfficient key column information for updating or refreshing
Enabled = True End Sub I ask the second question because it looks like you have some redundancy. You are currently viewing the Pro VB Databases section of the Wrox Programmer to Programmer discussions. I am joining two tables and displaying that data on a form that uses ADO. Description: Insufficient key column information for updating or refreshing. Move Next End If Loop End With Set edit SIrs1 = New ADODB. Open "SELECT ID, Quantity, Unit Cost, Total Cost FROM Stock In", edit SIcn1, 2, 3 Do While Not . Is there a problem with two connections being opened? As for the tables, you told me what they contain (which I can get from the field names (sort of) but not their purpose. That code is working well now but it open two connections. Declare one at the class level (or in a module) and use that one everywhere.This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. The process was working fine until I added another table. мы рассмотрели как правильно подключить БД MS Access в проект Delphi.Затем выбрав первой поле в свойстве Fild Name я прописал вручную fio, в том же свойстве для второго поля я прописал oz.
Open "SELECT Item Code, Quantity, Total Cost FROM Main Inventory", edit SIcn, 2, 3 Do While Not . These records will changes as stock is received and sold. Delivered='YES' FROM OPENQUERY(LINK_DB, 'SELECT * FROM XXXXR. O1') OQ JOIN OPENQUERY(LINK_DB, 'SELECT * FROM XXXXR. Dim miqty As Double Dim mitc As Double Dim siqty As Double Dim sitc As Double Dim diffqty As Double Dim difftc As Double Dim dvqty As Double Dim dvtc As Double dvqty = dynavqty. **Products** Contains one record for each unique product carried. *Product ID unique Weight unit weight in kilograms Dimensions unit size (WIDTH x DEPTH x HEIGHT) Colour Unit Cost Tax Rate expressed as 0.05 = 5% **Stock** Contains one record for each unique product.
Further tables might include a Customer table which assigns a unique Customer ID to each uniquue customer as well as an Orders table which would contain information about a specific order (what customer, which products and in what quantities, various dates - order Date, Shipping Date, etc).
Move Next End If Loop End With I'd have to see your table definitions to recommend a solution but the problem is that if you want to specify two tables in a query then the tables have to be related (share a common field).