The service or other provider returned an E_FAIL Status - HELP!

I am getting an unknown error message when loading one particular form during run-time. The error message is "The service or other provider returned an E_FAIL status".
I am trying to connect to a Visual FoxPro 6 table (the table is part of a database container and the other tables I connect to work just fine). I am using an ODBC connection, but I only have this problem with this particular form and it's related table.
Any ideas, suggestions??
Much Appreicated,
AD

Sorry, the exact error message is "The data provider or other service returned an E_FAIL Status".

Below is the start-up procedure for the form in case this helps determine the issue.

Thanks again for any help!



private Sub Form_Load()
on error GoTo err_FormLoad

'start-up procedures; fills in date, time and supq agent id
frmSupQ.Show
frmSupQ.SetFocus
ado_FxP_SupQ.Recordset.MoveLast
ado_FxP_SupQ.Recordset.AddNew
txtDate.Text = date
txtStart.Text = time
txtAgentID_SupQ.Text = frmLogin.txtAgentID.Text
txtAgentID_Xfer.SetFocus
me.Refresh
Exit Sub

err_FormLoad:
MsgBox Err.Number & Chr(10) & Err.Description & Chr(10) & Err.Source
resume next
End Sub

Try using the MS Jet 4.0 engine. Jet 3.51 would return this error when returning a recordset with too many fields (with an access db)

David Paulson

Does this apply even though I am using a FoxPro database? I am not using Jet to connect to the database, I am using ODBC/DSN to access the table. Plus, this only happens to this particular form and table. Everything else works fine.
??

Any ideas why I am still getting this error even though I am NOT using Jet to access the database? I am using ODBC/DSN for each form and related table, but I am only having problems with this one form.

Ideas?

Try limiting your recordset to the fields that you need. Like
SELECT Name, Address, City FROM Accounts instead of
Select * FROM Accounts. It is just a thought, I don't know foxpro.

David Paulson

Thanks for the help David, although I don't think it applies to this particular error because I am not running a SQL statement on Load.
I am however telling it to move to the last record and then add a new record, but again - I only have this problem with this table and form.
Any one else have some advice?
Thanks,
AD