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.
Printable View
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.
'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]
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.
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]
I think SQL Server uses Jet database engine too..
When you create a recordset from SQLServer table and work with this rs, VB uses JET engine
Iouri Boutchkine
[email protected]