{"id":16406,"date":"2024-03-15T12:54:32","date_gmt":"2024-03-15T12:54:32","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/"},"modified":"2025-08-07T02:41:44","modified_gmt":"2025-08-07T02:41:44","slug":"how-do-i-add-a-record-to-an-access-database-using-vb","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/","title":{"rendered":"How do I add a record to an Access database using VB?"},"content":{"rendered":"<p>To add records to an Access database, make sure you are already connected to the database. Create a connection using the OleDbConnection object provided by the ADO.NET library and open the connection.<\/p>\n<p>Next, create an INSERT INTO statement to insert new records into the table. Specify the table name, the fields to be inserted, and their corresponding values.<\/p>\n<p>Finally, execute the INSERT statement using the OleDbCommand object and then close the connection.<\/p>\n<p>Here is an example code:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">Imports<\/span> System.Data.OleDb\r\n\r\n<span class=\"hljs-keyword\">Public<\/span> <span class=\"hljs-keyword\">Sub<\/span> AddRecordToAccessDatabase()\r\n    <span class=\"hljs-comment\">' \u8fde\u63a5\u5b57\u7b26\u4e32<\/span>\r\n    <span class=\"hljs-keyword\">Dim<\/span> connectionString <span class=\"hljs-keyword\">As<\/span> <span class=\"hljs-type\">String<\/span> = <span class=\"hljs-string\">\"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\path\\to\\database.accdb\"<\/span>\r\n\r\n    <span class=\"hljs-comment\">' \u521b\u5efa\u8fde\u63a5\u5bf9\u8c61<\/span>\r\n    <span class=\"hljs-keyword\">Using<\/span> connection <span class=\"hljs-keyword\">As<\/span> <span class=\"hljs-built_in\">New<\/span> OleDbConnection(connectionString)\r\n        <span class=\"hljs-comment\">' \u6253\u5f00\u8fde\u63a5<\/span>\r\n        connection.Open()\r\n\r\n        <span class=\"hljs-comment\">' \u521b\u5efaINSERT\u8bed\u53e5<\/span>\r\n        <span class=\"hljs-keyword\">Dim<\/span> insertQuery <span class=\"hljs-keyword\">As<\/span> <span class=\"hljs-type\">String<\/span> = <span class=\"hljs-string\">\"INSERT INTO TableName (Field1, Field2) VALUES (@Value1, @Value2)\"<\/span>\r\n\r\n        <span class=\"hljs-comment\">' \u521b\u5efa\u547d\u4ee4\u5bf9\u8c61<\/span>\r\n        <span class=\"hljs-keyword\">Using<\/span> command <span class=\"hljs-keyword\">As<\/span> <span class=\"hljs-built_in\">New<\/span> OleDbCommand(insertQuery, connection)\r\n            <span class=\"hljs-comment\">' \u8bbe\u7f6e\u53c2\u6570\u503c<\/span>\r\n            command.Parameters.AddWithValue(<span class=\"hljs-string\">\"@Value1\"<\/span>, <span class=\"hljs-string\">\"Value1\"<\/span>)\r\n            command.Parameters.AddWithValue(<span class=\"hljs-string\">\"@Value2\"<\/span>, <span class=\"hljs-string\">\"Value2\"<\/span>)\r\n\r\n            <span class=\"hljs-comment\">' \u6267\u884cINSERT\u8bed\u53e5<\/span>\r\n            command.ExecuteNonQuery()\r\n        <span class=\"hljs-keyword\">End<\/span> <span class=\"hljs-keyword\">Using<\/span>\r\n\r\n        <span class=\"hljs-comment\">' \u5173\u95ed\u8fde\u63a5<\/span>\r\n        connection.Close()\r\n    <span class=\"hljs-keyword\">End<\/span> <span class=\"hljs-keyword\">Using<\/span>\r\n<span class=\"hljs-keyword\">End<\/span> <span class=\"hljs-keyword\">Sub<\/span>\r\n<\/code><\/pre>\n<p>In this example, replace &#8220;TableName&#8221; with the name of the table where records will be inserted, &#8220;Field1&#8221; and &#8220;Field2&#8221; with the corresponding fields in the table, and &#8220;@Value1&#8221; and &#8220;@Value2&#8221; as parameter names that can be customized along with their values as needed.<\/p>\n<p>Replace the connection string in the code with the actual database path and name.<\/p>\n<p>Make sure to reference the System.Data.OleDb namespace in the code to use the OleDbConnection and OleDbCommand classes.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To add records to an Access database, make sure you are already connected to the database. Create a connection using the OleDbConnection object provided by the ADO.NET library and open the connection. Next, create an INSERT INTO statement to insert new records into the table. Specify the table name, the fields to be inserted, and [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[453,1402,299,1404,1403],"class_list":["post-16406","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-development","tag-guide","tag-programming","tag-technology","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How do I add a record to an Access database using VB? - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn about how do i add a record to an access database using vb?. Comprehensive guide with examples and best practices.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do I add a record to an Access database using VB?\" \/>\n<meta property=\"og:description\" content=\"Learn about how do i add a record to an access database using vb?. Comprehensive guide with examples and best practices.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T12:54:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-07T02:41:44+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Noah Thompson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"How do I add a record to an Access database using VB?\",\"datePublished\":\"2024-03-15T12:54:32+00:00\",\"dateModified\":\"2025-08-07T02:41:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/\"},\"wordCount\":166,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Development\",\"guide\",\"programming\",\"technology\",\"tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/\",\"name\":\"How do I add a record to an Access database using VB? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T12:54:32+00:00\",\"dateModified\":\"2025-08-07T02:41:44+00:00\",\"description\":\"Learn about how do i add a record to an access database using vb?. Comprehensive guide with examples and best practices.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How do I add a record to an Access database using VB?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How do I add a record to an Access database using VB? - Blog - Silicon Cloud","description":"Learn about how do i add a record to an access database using vb?. Comprehensive guide with examples and best practices.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/","og_locale":"en_US","og_type":"article","og_title":"How do I add a record to an Access database using VB?","og_description":"Learn about how do i add a record to an access database using vb?. Comprehensive guide with examples and best practices.","og_url":"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T12:54:32+00:00","article_modified_time":"2025-08-07T02:41:44+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"How do I add a record to an Access database using VB?","datePublished":"2024-03-15T12:54:32+00:00","dateModified":"2025-08-07T02:41:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/"},"wordCount":166,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Development","guide","programming","technology","tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/","url":"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/","name":"How do I add a record to an Access database using VB? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T12:54:32+00:00","dateModified":"2025-08-07T02:41:44+00:00","description":"Learn about how do i add a record to an access database using vb?. Comprehensive guide with examples and best practices.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-do-i-add-a-record-to-an-access-database-using-vb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How do I add a record to an Access database using VB?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/16406","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=16406"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/16406\/revisions"}],"predecessor-version":[{"id":49951,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/16406\/revisions\/49951"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=16406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=16406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=16406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}