Delphi insufficient base table information for updating or refreshing psychsim 5 dating and mating tutorial

In fact, it does work for some MDB tables that I update, and doesn't for some others.

Data Source Hi Steve, Thanks for the tip but it must be something else.

Open "SELECT * from Descriptions WHERE Descriptions. Data Source = Rs This works fine as far as showing the grid with the correct data in at run time.

Fields("URN") & "';", Conn Main, ad Use Client, ad Lock Optimistic Set Data Grid1. I'm still new to ADO so I get a few things wrong still - anyway, I removed it and it worked!

I have an ADO dataset on one of my forms, but when I try increment an integer value, I get the error: "Insufficient base table information for updating or refreshing" My table has about 100 records, 2 columns(Var Char[Primary Key] and integer).

Source = "SELECT * From received ORDER BY received. What's funny is that some tables from the same MDB can be updated and some can't.

Is there, at you opinion, a problem when opening several tables from the same MDB, with a connection for each table?

Update I got the "Insufficient base table information for updating or refreshing" message. Rgds, Bernard here is the way I open the MDB: In General/Declarations: Private With Events global Connection As ADODB. Recordset In the Form_Load() global Provider = "Provider= Microsoft. OLEDB.3.51;" global Data Source = "Data Source=" & Text10 ' Text10 contains the path to the network volume where the MDB is located global Connect = global Provider & global Data Source Set global Connection = New ADODB.

Nom ' rscontacts is another MDB opened the same way rsprivate.

SQL statement: select * from generator where listfield = 'Test' In delphi: dataset.edit; dataset.fieldbyname('integervalue')Integer := dataset.fieldbyname('integervalue')Integer 1; dataset.post; **ERROR HERE*** - "Insufficient base table information for updating or refreshing" dataset has cursor Location, client, Cursor Type = ct Static Does anybody have any idea how to help.