Hi,
I've just upgraded an Access 97 db to SQL Server 7. The db is on a network drive and I need to allow multi user access to it using a VB front end. My question is how do I connect to a SQL Server 7 db using VB. The code I am using in VB at the moment to connect is:

Public cLocation As String
Public dbsOpen As Database

'
Public Sub dbOpenDB(cLocation)
'
Set dbsOpen = OpenDatabase(cLocation)
'
End Sub

I'm then creating recordsets as follows:

cSQL = "SELECT * FROM UserPasswords WHERE UserName='" & cmbUsers.Text & "'"

Set rEncrypt = dbsOpen.OpenRecordset(cSQL)

any help or advice anyone can give will be much appreciated

thanks

john