• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Cannot access design view in MS Access 2000

GiLtY

Golden Member
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.
 
Back
Top