Hi,

I have set up an Access Database and am using it in conjunction with a VB application. I have already linked using the VB Data Environment in order to produce reports from the database however now i need to do add, edit and delete functions on the records(preferably using the DE) Does anyone know the syntax on how? Ive tried a SQL statement as follows...

stSQL = "INSERT into DOSE_TABLE( DOSE_NUMBER,EARTAG_NUMBER,MEDICINE,WITHDRAWEL_PERIOD,FROM) VALUES ('11','2','3','4','5')"

deFarMate.conDatabase ?X? stSQL

?X?-using the object type connection you would put execute in here but i cannot find the suitable word for a DE that wont raise an error. Am i wayyy off the mark?

Please Help!!