Results 1 to 2 of 2
  1. #1
    mkc80 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    56

    Data Type Mismatch Error In Criteria Expression : Error 2001


    Hi,

    I copied a Access 2007 Database to Access 2010, and linked the tables to the Back End Database, but when I am trying to export an Excel file via a Switchboard which is the result of a macro,
    I get an error message 'Data Type Mismatch Error In Criteria Expression' and points to the statement in VBA code when I debug
    Set rs = DoCMD.Execute

    Is there something I should be doing when copying the 2007 DB to Access 2010?

    Any compatibility Issues?

  2. #2
    JeroenMioch's Avatar
    JeroenMioch is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    May 2012
    Location
    Den Haag, Netherlands
    Posts
    368
    Pretty soon were upgrading from MS-access 2003 to MS-access 2010 here at work. And i was told that access 2010 has Macro issues when they come from earlier versions of Access.

    But im not sure tbh.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Data type mismatch in criteria expression
    By bobt_1234 in forum Queries
    Replies: 3
    Last Post: 02-13-2012, 03:37 PM
  2. Data Type mismatch in criteria expression
    By elb1999 in forum Queries
    Replies: 2
    Last Post: 01-20-2012, 02:38 PM
  3. Replies: 2
    Last Post: 05-17-2011, 02:40 PM
  4. Data type mismatch in criteria expression
    By Douglasrac in forum Forms
    Replies: 3
    Last Post: 11-23-2010, 10:46 AM
  5. data type mismatch in criteria expression
    By broecher in forum Access
    Replies: 4
    Last Post: 09-10-2010, 08:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums