Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is this have any Problem ..............?

Status
Not open for further replies.

bzac

Programmer
Dec 20, 2000
55
US
Is there any problem in using this as a common connection.
(VB6-ADO2.5-Access2000)

Public dbHr As ADODB.Connection
Public dbHrflag As Boolean

Public Sub openDFSALHR()
'Open a common database connection
Set dbHr = New Connection

dbHr.CursorLocation = adUseClient
dbHr.ConnectionString = "provider= Microsoft.Jet.OLEDB.4.0;Data Source=\\ntfs-01\data\OCC\DFS\DFSALHR.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False"
dbHr.Open

dbHrflag = True
End Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top