Hi Sergey

Once again thanks a lot for your reply. I surely found a lot of valuable information which will make my life easier.

In my case I’m issuing and insert-SQL or delete-SQL statement through the Execute of the connection like state on message # 618251.

Trying this with the Tastrade database:

Set Conn = server.createObject("ADODB.Connection")
conn.provider="vfpoledb.1"
Conn.Open("dsn=TasTrade")
SQL = "insert into shippers (company_name) values ('New Company')"
Conn.Execute(SQL)
Conn.Close

What is very strange is that this very same code works perfectly on a Notebook with Windows XP Pro, but shows the error when tried at a PC with W2000.

I made a very exhaustive revision for the connection variables and all of them contain the same values, then a I assume that it has nothing to do with the connection.

What could it be that makes the ADO insert-SQL work only one machine?

Oscar


>See Re: Foxpro OLE DB Driver - Does it support updating??? Thread #617493 Message #617554.