I have a VB app which connects to a

[meBrian]

I have a VB app which connects to an Access DB.
Note:This app is running on dozens of PCs without error.
On 2 PCs when the app is run it returns the error

"Data Provider or other service returned an E_FAIL status"
when using the connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Drive:\Folder\database.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False

If I switch my connection to a DSN I still get the error in the same spot but the error message reads:

[Microsoft][ODBC Microsoft Access Driver]Data type mismatch in crteria expression

The error occurs on .movenext or .recordcount statements.

Again, this is only occuring on 2 PCs (Win2000 and XP). Initially, this app worked on both PCs. I'm not aware of any changes that would have contributed to this problem. Any help would be appreciated.

 

[Darrylles]

Hi,

Sorry me, you tried the net with "Data Provider or other service returned an E_FAIL status"?

Lot's of entries there that may indicate your problem solution.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[maxpower1]

in Control Panel under ODBC, turn on the trace. Set the path to where you want the log file to be dumped. Then run your program. You will notice some slowness because windows is logging every activity. when the error pops up, go back to ODBC and turn off the tracing(DO NOT LEAVE THIS ON since it will impair the connectivity!!). Check the traces in the log file. It usually wiil give you more specific errors.