{"id":68921,"date":"2024-12-03T19:08:43","date_gmt":"2024-12-03T19:08:43","guid":{"rendered":"https:\/\/www.accessrepairnrecovery.com\/blog\/?p=68921"},"modified":"2024-12-04T08:22:34","modified_gmt":"2024-12-04T08:22:34","slug":"ms-access-error-3464","status":"publish","type":"post","link":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-error-3464","title":{"rendered":"6 Ways to Solve MS Access Error 3464 effectively!"},"content":{"rendered":"<div class=\"8e1a49907eb0ebe2b39ac6355e555698\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">In this helpful article, I will discuss all about the Access warning message \u201c<strong>Run time error \u20183464\u2019: data type mismatch in criteria expression\u2026<\/strong>\u201d This error generally appears when a query encounters a mismatch between data types or attempting to filter out a SUBFORM when selecting a value in a combo box. It can disrupt workflow and hinder productivity. Therefore, let\u2019s delve into this blog and learn why MS Access error 3464 occur and how to fix it effectively.<!--more--><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-68922 aligncenter\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2024\/12\/MS-Access-error-3464.png\" alt=\"MS Access Error 3464\" width=\"492\" height=\"286\" \/><\/p>\n<div style='margin: 10px 0; clear: both;'><div style='clear: both; border-top: 1px solid #eeeeee; border-bottom: 1px solid #eeeeee; margin: 30px auto; padding: 15px 15px 15px 20px; display: flex; align-items: center; justify-content: space-between;'><div style='margin-bottom: 0; line-height: 1.6; flex-shrink: 1;'><span style='color:#aaa; font-size: 13px;'>Rated <i>Excellent<\/i> on <a rel='nofollow' target='_blank' href='https:\/\/www.trustpilot.com\/review\/www.stellarinfo.com'><span style='color: #aaa;'>Trustpilot<\/span><\/a><\/span><br><strong>Free MS Access Database Repair Tool<\/strong><br>Repair corrupt MDB and ACCDB database files and recover deleted database tables, queries, indexes and records easily. Try Now!<br><div style='margin-top: 5px;'><a style='background: #b10923; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 16px; font-weight: 500; padding: 0 16px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'><span style='color: #ffffff;'><i class='fas fa-arrow-alt-circle-down'><\/i><\/span> Download<\/a><br><span style='font-style: italic; display: block; font-size: 10px; margin-top: 10px;'>By clicking the button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the <a href='https:\/\/www.accessrepairnrecovery.com\/eula.php' target='_blank'>End User License Agreement<\/a> and <a href='https:\/\/www.accessrepairnrecovery.com\/privacy-policy.php' target='_blank'>Privacy Policy<\/a> of this site.<\/span><\/div><\/div><\/div><\/div>\n<h2 style=\"text-align: left;\"><strong>What Causes Microsoft Access Run Time Error 3464?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Before taking any action to get rid of this error, it is important to extract the roots. Although this message typically arises when the criteria query doesn\u2019t match the field\u2019s data type.<\/p>\n<p style=\"text-align: justify;\">So, here are the major factors:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Using improper date formats.<\/li>\n<li>Comparing text values with numeric fields.<\/li>\n<li>Incompatible data types in linked tables\/forms.<\/li>\n<li>DB file is locked.<\/li>\n<li>Corrupted Access database.<\/li>\n<\/ol>\n<h2 style=\"text-align: left;\"><strong>How to Fix Access \u2018Data Type Mismatch in Criteria Expression Error 3464\u2019?<\/strong><\/h2>\n<p style=\"text-align: justify;\">To identify and troubleshoot this error, follow the below methods carefully:<\/p>\n<div class=\"su-note\"  style=\"border-color:#d9d9d9;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f3f3f3;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<h3 style=\"text-align: left;\"><strong>Quick Fixes:<\/strong><\/h3>\n<ol style=\"text-align: justify;\">\n<li><strong><a href=\"#s1\">Restore from Available Backup<\/a><\/strong><\/li>\n<li><strong><a href=\"#s2\">Ensure to Correct Date Formats<\/a><\/strong><\/li>\n<li><strong><a href=\"#s3\">Import Corrupted Database Data into a New One<\/a><\/strong><\/li>\n<li><strong><a href=\"#s4\">Ensure the File is Not Locked\u00a0<\/a><\/strong><\/li>\n<li><strong><a href=\"#s5\">Run Compact &amp; Repair Tool<\/a><\/strong><\/li>\n<li><strong><a href=\"#s6\">Recommended \u2013 Use Access Repair &amp; Recovery Tool<\/a><\/strong><\/li>\n<\/ol>\n<\/div><\/div>\n<a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 1- Restore from Available Backup<\/strong><\/h3>\n<p style=\"text-align: justify;\">The\u00a0<strong>MS Access error 3464<\/strong> can occur due to incompatible data types or syntax error. Consequently, if you\u2019ve previously made a backup copy of your faulty database, you can restore it effectively from available backup.<\/p>\n<p><a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 2- Ensure to Correct Date Formats <\/strong><\/h3>\n<p style=\"text-align: justify;\">As already mentioned in the causes, inappropriate date &amp; time formats in the database can trigger this error message. Therefore, ensure to correct the date and time format to tackle this situation.<\/p>\n<blockquote><p><strong>Also Read: <a class=\"row-title\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-admin\/post.php?post=329&amp;action=edit\" aria-label=\"\u201cFixing MS Access \u201cCould Not Delete from Specified Tables\u201d (Error 3086)!\u201d (Edit)\">Fixing MS Access \u201cCould Not Delete from Specified Tables\u201d (Error 3086)!<\/a><\/strong><\/p><\/blockquote>\n<p><a name=\"s3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 3- Import Corrupted Database Data into a New One<\/strong><\/h3>\n<p style=\"text-align: justify;\">Creating a new database file and importing the entire old file data into new one can help you to deal with <strong>data type mismatch in criteria expression error 3464<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Here are the steps to be followed:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Open Microsoft Access then create a new file.<\/li>\n<li>Next, go to the <strong>File\u00a0<\/strong>tab then\u00a0<strong>Get External Data <\/strong>option<strong> &gt;&gt; Import<\/strong>.<\/li>\n<li>For importing the Access database, you have to click on\u00a0<strong>Access.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-67344 size-full\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2023\/03\/1-2.png\" alt=\"MS Access External Data\" width=\"641\" height=\"109\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2023\/03\/1-2.png 641w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2023\/03\/1-2-300x51.png 300w\" sizes=\"auto, (max-width: 641px) 100vw, 641px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>After that, you\u2019ll get an\u00a0<strong>external data Access Database\u00a0<\/strong>window\u00a0opened.<\/li>\n<li>Finally, go to\u00a0<strong>Tables\u00a0<\/strong>tab &gt;&gt; click on\u00a0<strong>Select All\u00a0<\/strong>&gt;&gt;\u00a0<strong>OK<\/strong>.<\/li>\n<\/ul>\n<p><a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 4- Ensure the File is Not Locked\u00a0to Fix MS Access Error 3464<\/strong><\/h3>\n<p style=\"text-align: justify;\">There might be possibility that the DB file you are trying to import might be locked or set to read-only mode. So, it is vital to check &amp; change this mode by following the steps mentioned below.<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Go to the location where the file is stored.<\/li>\n<li style=\"text-align: left;\">Right-click on the file &gt;&gt; click\u00a0<strong>Properties &gt;&gt; General\u00a0<\/strong>tab.<\/li>\n<li style=\"text-align: left;\">Find the\u00a0<strong><em>Attributes\u00a0<\/em><\/strong>section &gt;&gt; uncheck the\u00a0<strong>Read-only\u00a0<\/strong>box if it\u2019s checked.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-67831 aligncenter\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2020\/04\/remove-readonly.png\" alt=\"ReadOnly\" width=\"365\" height=\"441\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Now, click\u00a0<strong>apply\u00a0<\/strong>&gt;&gt;\u00a0<strong>OK<\/strong>.<\/li>\n<\/ul>\n<p><a name=\"s5\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 5- Run Compact &amp; Repair Tool<\/strong><\/h3>\n<p style=\"text-align: justify;\">Access database file corruption can cause <strong>run time error 3464<\/strong>. To <a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/repair-corrupt-access-database-without-data-loss\" target=\"_blank\" rel=\"noopener\"><strong>fix database corruption issues<\/strong><\/a> and solve the error, you can run the\u00a0<strong>Compact Repair<\/strong>\u00a0tool.<\/p>\n<p style=\"text-align: justify;\">Follow the below instructions to use this tool:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Open Access &gt;&gt; click\u00a0<strong>Database Tools<\/strong>.<\/li>\n<li style=\"text-align: left;\">Next, click on the\u00a0<strong>Compact and Repair Database <\/strong>option<strong>.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-67733 aligncenter\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/04\/click-database-compact-and-repair-database.webp\" alt=\"Compact and Repair Database\" width=\"739\" height=\"156\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Select a corrupted database file &gt;&gt; then click\u00a0<strong>Compact <\/strong>&amp; let Access repair it.<\/li>\n<\/ul>\n<p><a name=\"s6\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>Recommended \u2013 Use Access Repair &amp; Recovery Tool<\/strong><\/h2>\n<p style=\"text-align: justify;\">If you face any error or issues while handling the Access database, you can opt for an advanced\u00a0<a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool\" target=\"_blank\" rel=\"noopener\"><strong>Access Repair Tool<\/strong><\/a>. It is one of the award-winning software which is intended to repair the severely corrupt Access database .<strong>ACCDB<\/strong> and .<strong>MDB<\/strong> files with 100% integrity.<\/p>\n<p style=\"text-align: justify;\">Moreover, this tool can even help you to restore\u00a0<strong>records, tables, forms, indexes, modules<\/strong>,\u00a0<strong>queries, macros,<\/strong>\u00a0etc. Additionally, it can repair the password-protected forms &amp; modules.<\/p>\n<center><a href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'><img src='https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2020\/06\/en-dwn-btn.jpg' \/><\/a><p style='font-size:11px;'><font color='red'><b>*<\/b><\/font> By clicking the Download button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the <a href='https:\/\/www.accessrepairnrecovery.com\/eula.php' target='_blank'>End User License Agreement<\/a> and <a href='https:\/\/www.accessrepairnrecovery.com\/privacy-policy.php' target='_blank'>Privacy Policy<\/a> of this site.<\/p><\/center>\n<blockquote>\n<p style=\"text-align: left;\"><strong>Also Read: <a class=\"row-title\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-admin\/post.php?post=62947&amp;action=edit\" aria-label=\"\u201cSecrets to Resolving \u201cType Mismatch in Expression\u201d Access Error (3615)\u201d (Edit)\">Secrets to Resolving \u201cType Mismatch in Expression\u201d Access Error (3615)<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Frequently Asked Questions:<\/strong><\/h2>\n<h4 style=\"text-align: justify;\"><strong>How Do I Fix Data Type Mismatch in Criteria Expression?<\/strong><\/h4>\n<p style=\"text-align: justify;\">You can fix data type mismatch in criteria expression by checking the joined fields in your database queries.<\/p>\n<h4 style=\"text-align: left;\"><strong>What Is Data Type Mismatch Example?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Putting the number with fractions into the variable that\u2019s expecting only an integer.<\/p>\n<h4 style=\"text-align: left;\"><strong>How Do I Remove an Access Database Error?<\/strong><\/h4>\n<p style=\"text-align: justify;\">To remove a database error, try these tricks:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Check Your Database Credentials or Server.<\/li>\n<li>Fix Corrupted DB files.<\/li>\n<li>Create a New Database and import the old file data.<\/li>\n<\/ul>\n<h4 style=\"text-align: left;\"><strong>What Is the Size Limit of Access Database?<\/strong><\/h4>\n<p style=\"text-align: justify;\">2 GB (gigabytes) is the size limit of Access database.<\/p>\n<h2 style=\"text-align: left;\"><strong>Final Verdict<\/strong><\/h2>\n<p style=\"text-align: justify;\">The <strong>MS Access error 3464<\/strong> can be a major inopportuneness, nevertheless it\u2019s often fixable with some quick resolutions. Above, I have stated the best techniques to solve this annoying message in no time.<\/p>\n<p style=\"text-align: justify;\">Likewise, it is vital to do regular maintenance, updates, and careful data formats to prevent this error from occurring further.<\/p>\n<div class=\"su-note\"  style=\"border-color:#d9d9d9;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f3f3f3;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<p style=\"text-align: justify;\"><strong>References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/query-fails-error-3464-data-type-mismatch-in\/e0cfa68a-ccff-4d53-acca-9659c45e0611\" target=\"_blank\" rel=\"noopener\">https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/query-fails-error-3464-data-type-mismatch-in\/e0cfa68a-ccff-4d53-acca-9659c45e0611<\/a><\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/compact-and-repair-a-database-6ee60f16-aed0-40ac-bf22-85fa9f4005b2\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/compact-and-repair-a-database-6ee60f16-aed0-40ac-bf22-85fa9f4005b2<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<p style=\"text-align: justify;\"><div style='margin: 8px 0; clear: both;'><div style='border: 1px solid #e7e7e7; border-radius: 3px; background: #ffffff; color: #000; margin-top: 30px;'><div style='display: inline; background: #fff; padding: 10px; border: 1px solid #e7e7e7; border-bottom-right-radius: 10px; border-top-left-radius: 10px; border-top-right-radius: 10px; margin-left: -1px;'><img src='https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/12\/y-bulb.png' alt='tip' style='vertical-align: middle;' width='30px'><strong style='font-size: 18px; vertical-align: middle;'> Still having issues?<\/strong> Fix them with this Access repair tool: <\/div><div style='padding: 1rem; line-height: 1.6;'><p style='margin: 0; font-size: 17px;'>This software repairs & restores all ACCDB\/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.<\/p><div><ol style='font-size: 17px;'><li><strong><a href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'>Download Stellar Repair for Access <\/a><\/strong> rated <i>Great<\/i> on Cnet (<i>download starts on this page<\/i>).<\/li><li>Click <strong>Browse<\/strong> and <strong>Search<\/strong> option to locate corrupt Access database.<\/li><li>Click <strong>Repair<\/strong> button to repair & preview the database objects.<\/li><\/ol><\/div><\/div><\/div><\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>In this helpful article, I will discuss all about the Access warning message \u201cRun time error \u20183464\u2019: data type mismatch &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"6 Ways to Solve MS Access Error 3464 effectively!\" class=\"read-more button\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-error-3464#more-68921\" aria-label=\"Read more about 6 Ways to Solve MS Access Error 3464 effectively!\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":68923,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1021],"tags":[1939,1938,1940],"class_list":["post-68921","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fix-errors","tag-data-type-mismatch-in-criteria-expression-error-3464","tag-ms-access-error-3464","tag-run-time-error-3464","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>6 Ways to Solve MS Access Error 3464 effectively!<\/title>\n<meta name=\"description\" content=\"Follow the guidelines mentioned here to fix MS Access error 3464 data type mismatch in criteria expression &amp; ensure a smoother DB experience.\" \/>\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.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"6 Ways to Solve MS Access Error 3464 effectively!\" \/>\n<meta property=\"og:description\" content=\"Follow the guidelines mentioned here to fix MS Access error 3464 data type mismatch in criteria expression &amp; ensure a smoother DB experience.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close\" \/>\n<meta property=\"og:site_name\" content=\"MS Access Repair And Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-03T19:08:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-04T08:22:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2024\/12\/MS-Access-error-3464-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"310\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Pearson Willey\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pearson Willey\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close\"},\"author\":{\"name\":\"Pearson Willey\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\"},\"headline\":\"6 Ways to Solve MS Access Error 3464 effectively!\",\"datePublished\":\"2024-12-03T19:08:43+00:00\",\"dateModified\":\"2024-12-04T08:22:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close\"},\"wordCount\":874,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2024\/12\/MS-Access-error-3464-1.png\",\"keywords\":[\"data type mismatch in criteria expression error 3464\",\"MS Access error 3464\",\"run time error 3464\"],\"articleSection\":[\"Fix Access Errors\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close\",\"name\":\"6 Ways to Solve MS Access Error 3464 effectively!\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2024\/12\/MS-Access-error-3464-1.png\",\"datePublished\":\"2024-12-03T19:08:43+00:00\",\"dateModified\":\"2024-12-04T08:22:34+00:00\",\"description\":\"Follow the guidelines mentioned here to fix MS Access error 3464 data type mismatch in criteria expression & ensure a smoother DB experience.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#primaryimage\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2024\/12\/MS-Access-error-3464-1.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2024\/12\/MS-Access-error-3464-1.png\",\"width\":550,\"height\":310},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"6 Ways to Solve MS Access Error 3464 effectively!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"name\":\"MS Access Repair And Recovery Blog\",\"description\":\"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More\",\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\",\"name\":\"MS Access Repair And Recovery Blog\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"MS Access Repair And Recovery Blog\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\",\"name\":\"Pearson Willey\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"caption\":\"Pearson Willey\"},\"description\":\"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"6 Ways to Solve MS Access Error 3464 effectively!","description":"Follow the guidelines mentioned here to fix MS Access error 3464 data type mismatch in criteria expression & ensure a smoother DB experience.","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.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close","og_locale":"en_US","og_type":"article","og_title":"6 Ways to Solve MS Access Error 3464 effectively!","og_description":"Follow the guidelines mentioned here to fix MS Access error 3464 data type mismatch in criteria expression & ensure a smoother DB experience.","og_url":"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close","og_site_name":"MS Access Repair And Recovery Blog","article_published_time":"2024-12-03T19:08:43+00:00","article_modified_time":"2024-12-04T08:22:34+00:00","og_image":[{"width":550,"height":310,"url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2024\/12\/MS-Access-error-3464-1.png","type":"image\/png"}],"author":"Pearson Willey","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Pearson Willey","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#article","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close"},"author":{"name":"Pearson Willey","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb"},"headline":"6 Ways to Solve MS Access Error 3464 effectively!","datePublished":"2024-12-03T19:08:43+00:00","dateModified":"2024-12-04T08:22:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close"},"wordCount":874,"commentCount":0,"publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2024\/12\/MS-Access-error-3464-1.png","keywords":["data type mismatch in criteria expression error 3464","MS Access error 3464","run time error 3464"],"articleSection":["Fix Access Errors"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close","name":"6 Ways to Solve MS Access Error 3464 effectively!","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#primaryimage"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2024\/12\/MS-Access-error-3464-1.png","datePublished":"2024-12-03T19:08:43+00:00","dateModified":"2024-12-04T08:22:34+00:00","description":"Follow the guidelines mentioned here to fix MS Access error 3464 data type mismatch in criteria expression & ensure a smoother DB experience.","breadcrumb":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#primaryimage","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2024\/12\/MS-Access-error-3464-1.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2024\/12\/MS-Access-error-3464-1.png","width":550,"height":310},{"@type":"BreadcrumbList","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/tag\/microsoft-access-wont-close#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.accessrepairnrecovery.com\/blog\/"},{"@type":"ListItem","position":2,"name":"6 Ways to Solve MS Access Error 3464 effectively!"}]},{"@type":"WebSite","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","name":"MS Access Repair And Recovery Blog","description":"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More","publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization","name":"MS Access Repair And Recovery Blog","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","width":350,"height":70,"caption":"MS Access Repair And Recovery Blog"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb","name":"Pearson Willey","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","caption":"Pearson Willey"},"description":"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey"}]}},"_links":{"self":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/68921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/comments?post=68921"}],"version-history":[{"count":1,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/68921\/revisions"}],"predecessor-version":[{"id":68926,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/68921\/revisions\/68926"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media\/68923"}],"wp:attachment":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media?parent=68921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/categories?post=68921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/tags?post=68921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}