dcsimg
Page 2 of 2 FirstFirst 12
Results 41 to 43 of 43

Thread: ADD,DELETE,UPDATE the records in the access database

  1. #41

    Thread Starter
    Member
    Join Date
    May 2019
    Posts
    39

    Re: ADD,DELETE,UPDATE the records in the access database

    Code:
    
        Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            DataGridView1.EditMode = False
            txtID.ReadOnly = True
            da.MissingSchemaAction = MissingSchemaAction.AddWithKey
            cnn.ConnectionString = ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Projects\Library Frontend\Database\Backup\Mentor_DX_Library_Database.accdb;Persist Security Info=False;")
            Try
                cnn.Open()
                'Filter out the temporary tables
                Dim restrictions() As String = New String(3) {}
                restrictions(3) = "Table"
                Me.ComboBox1.DisplayMember = "TABLE_NAME"
                Me.ComboBox1.DataSource = cnn.GetSchema("Tables", restrictions)
                DataGridView1.BeginEdit(False)
            Catch ex As Exception
                MessageBox.Show(ex.ToString)
                cnn.Close()
            End Try
    
        End Sub
    Still it shows the temporary tables on my combobox. i dont know why, even after adding the restrictions to the database.

  2. #42
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,091

    Re: ADD,DELETE,UPDATE the records in the access database

    That question is so different to what was being discussed before that it belongs in a different thread.

    While it saves you a few seconds to post multiple questions in the same thread, the amount and/or quality of help you get tends to be far lower. Many people will stay away from threads with 10+ replies, as it is much harder to know what the actual question at hand is (the prior posts may or may not be relevant, but it will take a lot of reading to find out).

    As a general guide each thread should only deal with one specific issue.

  3. #43
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    102,752

    Re: ADD,DELETE,UPDATE the records in the access database

    Quote Originally Posted by si_the_geek View Post
    That question is so different to what was being discussed before that it belongs in a different thread.
    I think that that is literally true, i.e. the OP posted to the wrong thread. That post belongs here:

    http://www.vbforums.com/showthread.php?877329

Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width