Connection string to access

[ohadbp]

hi guys,

i am building a project using VB and a Databe created in Access.
can i connect to the database without using the ODBC Data source??

thanks,
ohad.

[Iouri]

'connection to secure database
Dim Cnn As ADODB.Connection
Dim sConn As String

Set Cnn = New ADODB.Connection

sConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & DBNAME & _
";Persist Security Info=False"

With Cnn
.CursorLocation = adUseClient
.Open sConn
End With


Iouri Boutchkine
[email protected]

[ohadbp]

hi,

first of all thanks for your help.
using the adodc i found how i create a connection
string to sql oracle and i saw the jet thing, but didnt knew he support access.

can you tell me what is this jet thing?
what more he support except access?

thanks,
ohad.

[Iouri]

JET is the database engine. I forgot what JET stands for, but it has nothing to do with jet planes. Access and VB have the same engine JET and used mainly for supporting Access.

Iouri Boutchkine
[email protected]

[Boumxyz2]

I think SQL Server uses Jet database engine too..

[Iouri]

When you create a recordset from SQLServer table and work with this rs, VB uses JET engine

Iouri Boutchkine
[email protected]