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
iouri@hotsheet.com

[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
iouri@hotsheet.com

[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
iouri@hotsheet.com