Hi there!,

I wonder if anyone could help me! plz.

I have opened up an ADO recordset using an SQL query.
However when I try to change the textfields in anyway i get
the error message

Run-time error '-2147467259(80004005)': Insufficient base table information for updating or refreshing.

Now i know this because of the query, but I also tried updateing the database via another adorecordset. And when i go back 2 the original recordset to move it to the next record i get the same error message.

How do i save 2 the database or make any other changes?.

the sql query i have used is

SELECT Suppliers.ContactName, Suppliers.Address,Suppliers.City,Suppliers.PostalCode,Suppliers.Phone,Suppliers.Fax,Suppliers.Compan yName, Product.ProductName ,Product.Price,Product.[Batch Number] FROM Suppliers INNER JOIN Product ON Suppliers.SupplierID = Product.Supplier;

plz help!