insert record in foxpro table

[dav]

hi
I always use DAO e don't konw well other methods like ADO. This is the code
I wrote:

table 'tblFOXPRO' connect by odbc

Dim DS As DAO.Recordset
Set DS = CurrentDb.OpenRecordset("SELECT tblFOxPRO* FROM tblFOxPRO";")
With DS
.AddNew
!ID = 1
!CAMPO1 = A
!CAMPO2 = B
.Update
End With

This is the error I read:

ERRORE RUN-TIME 3146
ODBC: CHIAMATA NON RIUSCITA

when I do debug the yellow sign is on ".update" . Maybe I forgot any option
in openrecordset? thanks

 

[OfficeDev18 via AccessMonster.com]

In your ODBC connection, do you have any linked fields? If not, you cannot
add any records to the FoxPro table.

Hope this helps,

Sam

 

[René François]

When you pen the recordset, add the optional parameter DbOpenSeeChanges,
like this:
Set DS = CurrentDb.OpenRecordset("SELECT tblFOxPRO* FROM tblFOxPRO";",
DbOpenSeeChanges)