Datagrid

[WornOut]

I'm converting from Access 2000 to SQL Svr 2000. My VB code uses a datagrid. However, although I set allowaddnew, allowdelete, allowupdate all to true, I'm not able to perform those functions on the displayed table. Why ?

Thanks

 

[jmerencilla]

can you paste a snippet of your code here where you access the SQL server and display the data on the datagrid? this will help in debugging your problem

 

[WornOut]

Private Sub Form_Load()

Set Db = Nothing
ConnectionString = "driver={SQL Server};" & _
"server=File;" & _
"uid=;pwd=;" & _
"database=Cash Management;"
MsgBox "Connection string setup new ver"
With Db
.ConnectionString = ConnectionString
.ConnectionTimeout = 20
.Open
End With

SQLLineItem.Open "Select * from lineitem", Db, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = SQLLineItem
DataGrid1.AllowAddNew = True
DataGrid1.AllowArrows = True
DataGrid1.AllowDelete = True
DataGrid1.AllowUpdate = True
DataGrid1.WrapCellPointer = True
DataGrid1.TabAction = dbgGridNavigation

End Sub

 

[kishleo]

well, i think if you post this code on the VB forum you can get the clear answer, why dont you post it there? ô¿ô Kishore