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

[goddess_spanky]

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

[goddess_spanky]

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

[d.paulson]

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

[goddess_spanky]

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.
??

[goddess_spanky]

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?

[d.paulson]

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

[goddess_spanky]

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