Click here to Skip to main content
16,009,057 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionCommunication between computers... Pin
Subjugate8-Dec-08 19:00
Subjugate8-Dec-08 19:00 
AnswerRe: Communication between computers... Pin
Steven J Jowett9-Dec-08 0:11
Steven J Jowett9-Dec-08 0:11 
GeneralRe: Communication between computers... Pin
Subjugate9-Dec-08 16:14
Subjugate9-Dec-08 16:14 
GeneralRe: Communication between computers... Pin
Steven J Jowett10-Dec-08 1:33
Steven J Jowett10-Dec-08 1:33 
GeneralRe: Communication between computers... Pin
Subjugate10-Dec-08 14:14
Subjugate10-Dec-08 14:14 
QuestionVideo Implementation Pin
Johndas8-Dec-08 18:40
Johndas8-Dec-08 18:40 
AnswerRe: Video Implementation Pin
Christian Graus8-Dec-08 19:42
protectorChristian Graus8-Dec-08 19:42 
QuestionCreating a MS Access 2007 Database problem... Pin
VIP-CoMmAnDo8-Dec-08 11:31
VIP-CoMmAnDo8-Dec-08 11:31 
Hi,

I'm having a problem when creating an ms access database using the following code:

Imports System.Data.OleDb

Public Class Database

    Public Function CreateDatabase(ByVal FileName As String) As Boolean

        Dim ADOXCatalog As ADOX.Catalog = New ADOX.Catalog
        Dim ADOXTable As ADOX.Table = New ADOX.Table
        Dim ADOXindex As ADOX.Index = New ADOX.Index
        Dim oConnect As String

        oConnect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & FileName

        Try

            ADOXCatalog.Create(oConnect)

            ADOXTable.Name = "tblContacts"
            ADOXTable.Columns.Append("ID", ADOX.DataTypeEnum.adInteger)
            ADOXTable.Columns.Append("Nick", ADOX.DataTypeEnum.adVarChar, 64)
            ADOXTable.Columns.Append("RealName", ADOX.DataTypeEnum.adVarChar, 64)
            ADOXTable.Columns.Append("Age", ADOX.DataTypeEnum.adInteger)
            ADOXTable.Columns.Append("BirthDate", ADOX.DataTypeEnum.adDate)
            ADOXTable.Columns.Append("Address", ADOX.DataTypeEnum.adVarChar, 256)
            ADOXTable.Columns.Append("PhoneNum", ADOX.DataTypeEnum.adVarChar, 32)
            ADOXTable.Columns.Append("email1", ADOX.DataTypeEnum.adVarChar, 64)
            ADOXTable.Columns.Append("email2", ADOX.DataTypeEnum.adVarChar, 64)
            ADOXTable.Columns.Append("email3", ADOX.DataTypeEnum.adVarChar, 64)
            ADOXTable.Columns.Append("Notes", ADOX.DataTypeEnum.adVarChar, 4096)

            ADOXCatalog.Tables.Append(ADOXTable)

            ADOXindex.Name = "IDindex"
            ADOXindex.Columns.Append("ID")

            ADOXTable.Indexes.Append(ADOXindex)

        Catch ex As System.Runtime.InteropServices.COMException
        Catch ex As Exception

            MsgBox(ex.Message & vbCrLf & ex.StackTrace)
            Return False

        Finally

            ADOXCatalog = Nothing

        End Try

        Return True

    End Function
End Class


the database gets created but when i open it using MS access 2007 it's empty.. no tables Frown | :(
QuestionDrag And Drop Into A Datagrid Pin
Phantom7158-Dec-08 11:22
Phantom7158-Dec-08 11:22 
QuestionAdd records to recordset after executing the stored procedure in vb 6.0 Pin
Parag Raibagkar8-Dec-08 7:17
Parag Raibagkar8-Dec-08 7:17 
AnswerRe: Add records to recordset after executing the stored procedure in vb 6.0 Pin
Christian Graus8-Dec-08 9:46
protectorChristian Graus8-Dec-08 9:46 
QuestionDataset.ReadXML Pin
ndroo8828-Dec-08 4:13
ndroo8828-Dec-08 4:13 
AnswerRe: Dataset.ReadXML Pin
ndroo8828-Dec-08 4:13
ndroo8828-Dec-08 4:13 
QuestionUnloading assembly Pin
cstrader2328-Dec-08 3:17
cstrader2328-Dec-08 3:17 
AnswerRe: Unloading assembly Pin
Gideon Engelberth8-Dec-08 3:38
Gideon Engelberth8-Dec-08 3:38 
GeneralRe: Unloading assembly Pin
cstrader2328-Dec-08 9:12
cstrader2328-Dec-08 9:12 
GeneralRe: Unloading assembly Pin
cstrader2329-Dec-08 3:49
cstrader2329-Dec-08 3:49 
QuestionWhy displays look different Pin
cstrader2328-Dec-08 3:16
cstrader2328-Dec-08 3:16 
AnswerRe: Why displays look different Pin
Colin Angus Mackay8-Dec-08 3:18
Colin Angus Mackay8-Dec-08 3:18 
GeneralRe: Why displays look different Pin
cstrader2329-Dec-08 3:48
cstrader2329-Dec-08 3:48 
GeneralRe: Why displays look different Pin
Colin Angus Mackay9-Dec-08 3:56
Colin Angus Mackay9-Dec-08 3:56 
GeneralRe: Why displays look different Pin
Jon_Boy9-Dec-08 4:48
Jon_Boy9-Dec-08 4:48 
GeneralRe: Why displays look different Pin
cstrader2329-Dec-08 4:51
cstrader2329-Dec-08 4:51 
GeneralRe: Why displays look different Pin
Jon_Boy9-Dec-08 4:59
Jon_Boy9-Dec-08 4:59 
GeneralRe: Why displays look different Pin
cstrader2329-Dec-08 5:02
cstrader2329-Dec-08 5:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.