Cannot access design view in MS Access 2000

GiLtY

Golden Member
Sep 10, 2000
1,487
1
0
I'm using Access 2000 as my database. In one of the pages (using .NET) I opened one of the tables and bound to it. After I bind a datalist control to the table, I cannot open design view in all of the tables.

Here's the segment of the code that dealt with opening connection:

Dim myConnection As OLEDBConnection
Dim myCommand As OLEDBCOmmand
Dim myReader As OLEDBDataReader
Dim SQLstr As String
DIm connString As String
Dim RecpUserID As Integer

RecpUserID = 1


SQLstr = "SELECT * From Threads Where RecpUserID=" & RecpUserID & " and isNew=1 ORDER BY ThreadID DESC"
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\GiltY\ASP.NET\db\GDB.mdb;User Id=;Password=;"
myConnection = New OLEDBConnection (connString)
myCommand = New OLEDBCOmmand (SQLstr, myCOnnection)
myConnection.open()
myReader = myCommand.ExecuteReader()
infoList.Datasource = myReader
infoList.Databind()
myConnection.close()


Thanks for any help.