Insufficient base table information for updating or refreshing?
It seems you have no primary key for that table. The SQL-server(or access!)
needs keys to
identify the record youre editing. In your case ,the server didt know
which record to update??
greets
nico balen
database programmer,.germany
one hint: you can combine these to rows of code
Dim Rs As ADODB.Recordset
Set Rs = New ADODB.Recordset
to
Dim Rs As new ADODB.Recordset
Quote:
> I am using VB6-ADO-Access 97 database. On one form I have a datagrid
> control with an ADO recordset as its data source - the code is as
> follows: -
> Dim Rs As ADODB.Recordset
> Set Rs = New ADODB.Recordset
> Rs.Open "SELECT * from Descriptions WHERE Descriptions.LinkField = '" &
> datPrimaryRS.Recordset.Fields("URN") & "';", ConnMain, adUseClient,
> adLockOptimistic
> Set DataGrid1.DataSource = Rs
> This works fine as far as showing the grid with the correct data in at
> run time. However, when I edit the text within a cell and then cause
> the update event to fire I get the following message and the update
> does not occur: -
> "Insufficient base table information for updating or refreshing"
> Can anyone advise me of the cause of this message and how to fix the
> problem? I can't find mention of it in the help section.
> Thanks,
> Ian B
> Sent via Deja.com http://www.deja.com/
> Before you buy.
