Hello,
First of all I am using VB 6 and the Visual Data Manager to create the database.

I have the following line of code :

plotadder.RecordSource = "INSERT INTO Plot (Title, Agent_id, Location, Price, Type, Bedrooms, Bathrooms, FloorArea, Description, photo, builton) values('" & txttitle.Text & "'," & txtagentid.Text & ",'" & txtlocation.Text & "'," & txtprice.Text & ",'" & cmbtype.Text & "'," & cmbbathrooms.Text & "," & cmbbedrooms.Text & "," & txtfloorarea.Text & ",'" & txtdescription.Text & "','" & App.Path & "\photos\" & txttemp.Text & "'," & cmbbuiltin.Text & ")"

This is supposed to insert a record into the database, but it doesn't and nor does it produce any error at runtime However using Debug.print i get the following output :
INSERT INTO Plot (Title, Agent_id, Location, Price, Type, Bedrooms, Bathrooms, FloorArea, Description, photo, builton) values('sfdf',2,'sdf',343234,'Apartment',01,01,234324,'sdfsdfds','C:\22 Acres\photos\3.jpg',1980)

Which works perfectly fine while running the query in Visual Data Manager
What's going wrong ?