I'm trying to design a web part for Sharpoint server. A web part is basically an ASP.NET custom control. I thought this would be the appropriate place to post about the bug I have. The only way I can test my control is by putting it onto the Sharepoint Portal Server, and so the debugging is very hard to do, but all I know is my code has some bug in it that Sharepoint doesn't like. I'm basically trying to import an Access Database, and display it on Sharepoint.

PHP Code:
Imports System
Imports System.ComponentModel
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Xml.Serialization
Imports Microsoft.SharePoint
Imports Microsoft.SharePoint.Utilities
Imports Microsoft.SharePoint.WebPartPages
Imports System.Data.OleDb

<DefaultProperty("Text"), ToolboxData("<{0}:WebPart1 runat=server></{0}:WebPart1>"), XmlRoot(Namespace:="TestWebPart")> _
 Public Class MyWebPart
    Inherits WebPart
    Dim dg As DataGrid
    Protected Overrides Sub CreateChildControls()
        dg = New DataGrid
        Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " & _
            "Data Source=C:\users.mdb")
        conn.Open()
        Dim adapter As New OleDbDataAdapter("SELECT * FROM Users", conn)
        Dim ds As New DataSet
        adapter.Fill(ds)
        dg.DataSource = ds
        Controls.Add(dg)
    End Sub
    Protected Overrides Sub RenderWebPart(ByVal Output As HtmlTextWriter)
        EnsureChildControls()
        dg.RenderControl(Output)
    End Sub
End Class 
users.mdb is my database, and Users is the table inside it that I want to display. Does anyone see a bug in my code? I was also thinking that maybe there might be a problem with the link, since I'm compiling on my pc, which has the database on it, and then uploading to the sharepoint server. Any suggestions?