connecting to ACCESS database - bypassing JET

[CPUburn]

Hi y'all

I'd like to know if there's a possibility to bypass completely msjet35/40 opening an access database trough vb6. I don't wanna use sql-server.

thx

the kid

 

[petermeachem]

Why?

 

[MatsHulten]

You could try using the MSDASQL provider. It is the default provider for windows, but I can't guarantee that it in iturn wont call the Jet provider.

Bear in mind that Jet is the DB-engine, so even if you can bybass the Jet DB provider, you would still be talking to it.

Why would you want to avoid the Jet provider?

-Mats

 

[BBaggins]

You wouldn't want to do that, even if you could. msjetXX is the native engine, and there is no faster way to talk to an Access db.

Maybe what you meant to ask is how to bypass ODBC? That's a more sensible question.