Results 1 to 5 of 5
  1. #1
    baranisankar is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2017
    Posts
    2

    MS Access - Getting Unknown error message when running query with huge data records

    Hi,
    I am getting Unknown error message when running query with huge data records in MS Access 2007, can I have a solution for this?

    Thanks in advance for your help

    Regards,
    Sankar

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,264
    not much to go on. best I can suggest:

    db is corrupted
    you are using improper field names (includes non alphanumeric characters or is a reserved word)
    your query is an append or make table query and you are exceeding the db size limit of 2Gb
    you have invalid data in your source fields (e.g. unhandled nulls, includes 'non date' text in a date field, perhaps " or ' in a text field, etc)

  3. #3
    baranisankar is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2017
    Posts
    2
    thanks for the suggestion, i don't have any problem with what your have mentioned, later i came to know that one of my database column value has more than 2000+ character and it has been declared as "Text" hence my query is not running. After i changed the variable as "memo", I can run the query. Unknown error is fixed now.

    And I have another question, can you help me on that, I have imported 700,000 records using link option, and i can't change the Data Type each column, and it has been set automatically, so is there any way to change the Data Type, I tried changing the Data Type manually but it throwing a message "Microsoft Office Access can't save property changes for linked tables" and I cant save.
    ,

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,862
    I think you would need to physically import the records in order to be able to change the Data Types.
    I don't think you can do that for linked Tables.

    What kind of file is this linked table? Is it something where you can change the Data Type in the Source (i.e. if it is from another database)?

    A lot of times when Access is looking to determine to automatically set the field type on fields, it looks at something like the first 10 records. So, if you can get some data in the first 10 records that would force it from one data-type to another, that might work (i.e. make sure one of your first ten entries has an entry of over 2000 characters, if you want to force it to be a Memo instead of Text).
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  5. #5
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,264
    or rather than importing to a new table. Have an empty table structured as you require

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

Similar Threads

  1. "Unknown" message error while opening a query
    By falahsalih in forum Access
    Replies: 7
    Last Post: 05-23-2014, 04:58 PM
  2. Receiving Error Message when running Query second time
    By alansidman in forum Programming
    Replies: 3
    Last Post: 03-20-2014, 08:55 AM
  3. Replies: 1
    Last Post: 01-23-2012, 11:54 PM
  4. Replies: 13
    Last Post: 06-20-2011, 12:18 PM
  5. Replies: 2
    Last Post: 09-30-2009, 09:40 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 - Senior Forums