Results 1 to 3 of 3
  1. #1
    Mclaren is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164

    access 2010 to 2003 conversion

    OK so i need to convert some 2010 tables to 2003. i have removed all object except the tables. When saving and publiching to the 2003 format, i am getting the error message :


    The specified database sort order, General, is not supported for the target database format
    I am not sure what this means. My lookup fields are all set to "Ascending", there is no general in look up fields. What the heck could be the problem.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    You can't save tables in 2003 format, you basically have to save the whole database as access 2003, is that what you're trying to do? if so remove the lookup component of the table you're exporting or import the table you're using to look up the value first, then import the table you're having trouble with.

  3. #3
    Mclaren is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164
    I eventually got it right by exporting each table to a access 2003 DB.

    I was trying to save it as a 2003 database, and that was the error i got.

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

Similar Threads

  1. Change Access 2003 mdb workgroup using Access 2010
    By metsmaniac in forum Security
    Replies: 6
    Last Post: 04-06-2012, 08:56 PM
  2. Replies: 9
    Last Post: 08-07-2011, 11:21 AM
  3. Replies: 1
    Last Post: 06-23-2011, 07:19 AM
  4. Replies: 1
    Last Post: 01-11-2011, 12:31 PM
  5. 2003 to 2007 conversion error
    By paleoman in forum Access
    Replies: 1
    Last Post: 06-22-2010, 04:33 PM

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