Hello to all. I'm try to connect a ADO database whit this routine:
Dim Db As ADODB.Connection
Dim Rs As ADODB.Recordset
Dim strSQL As String
Set Db = New ADODB.Connection
Set Rs = New ADODB.Recordset
strSQL = "SELECT * FROM TableTest;"
Db.Provider = "Microsoft.Jet.OLEDB.4.0;"
Db.ConnectionString = "Data Source=\\Sole\Dati\Filiere\STANDARD\TabeleTest.mdb;"
Db.Open
Rs.Open strSQL, Db, adOpenDynamic, adLockOptimistic (***)
But in row (***) VBA show me this error:
Unable to read record. Read authorization required for "TableTest"
The proprety Mode is: adModeShareDenyNone
After i try to set the UserID and Password user proprety in connection string:
Data Source=\\Sole\Dati\Filiere\STANDARD\ElencoRevisioni.mdb;UserID=UfficioTecnico;Password=Atena
But VBA show me this error:
Unable to start application.Information file of workgroup is missing... (italian traslation sorry)
Can i set the path of WorkGroup file or solve my problems in another metohd?
Can i use DAO?
Thx to all and sorry for my bad english.
FAZ.
