User Profile

Collapse

Profile Sidebar

Collapse
Amr Ali
Amr Ali
Last Activity: Dec 21 '11, 07:38 AM
Joined: Dec 13 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Amr Ali
    started a topic Error Operation must use an Updatable Query
    in Access

    Error Operation must use an Updatable Query

    When I am running the following sql statement
    Code:
     UPDATE [Daily Embossing] LEFT JOIN [2_Embossing Did Trnx] ON [Daily Embossing].[Account No] = [2_Embossing Did Trnx].[Account No] SET [Daily Embossing].Xclusive_Issued = True 
WHERE ((Not ([2_Embossing Did Trnx].[Account No]) Is Null));
    , i am getting this error "Operation must use an updatable query".

    Please help me to fix this issue.
    See more | Go to post
    • Amr Ali
      replied to Speed Up Access Query to CSV Linked Tables
      in Access
      Mihail,

      i read your post again and i attached the csv file columns on my reply and regarding your questions:

      - How you want to be divided ?
      i need it to be separated after every 105 columns and 250,000 row.

      - What names you wish for each column ?
      as attached in my file.

      - What is the max size you need ?
      max size that it will be light when making a search query.
      See more | Go to post

        Leave a comment:

      • Amr Ali
        replied to Speed Up Access Query to CSV Linked Tables
        in Access
        Mihail,

        Thank you so much for your fast reply and for helping me, but i would like to attract your attention that i'll do it frequently on a weekly basis.
        Regarding importing the csv file into word pad, i think it will be the worse choise coz i tried it before and after 2 hours it hanged and froze without success.
        I attached a zip file what includes all column headers which will help you to do what you suggested before....
        See more | Go to post

          Leave a comment:

        • Amr Ali
          replied to Speed Up Access Query to CSV Linked Tables
          in Access
          it's delimited with | separator and includes 209 columns of data and about 500,000 rows
          See more | Go to post

            Leave a comment:

          • Amr Ali
            replied to Speed Up Access Query to CSV Linked Tables
            in Access
            how can i control the size of csv imported data while i can't open this csv file as it's sooo huge 800 MB
            See more | Go to post

              Leave a comment:

            • Amr Ali
              replied to Speed Up Access Query to CSV Linked Tables
              in Access
              Rabbit,
              i am using all fields as text while importing the file but access doesn't let me completing the process as it shows me an error ## invalid argument coz the max size was reached.
              See more | Go to post

                Leave a comment:

              • Amr Ali
                started a topic Speed Up Access Query to CSV Linked Tables
                in Access

                Speed Up Access Query to CSV Linked Tables

                I have a microsoft access database ver. 2003 with linked table to a huge csv file. This csv file is about 800 MB size what couldn't be imported to access by any way because each time I am trying to import it, it exceeds the max size of an access database. I need to make a search query into this linked table but when I am running such query it hangs and freezes because the linked tables couldn't be indexed. So, I need your advice to fix this issue...
                See more | Go to post
                No activity results to display
                Show More
                Working...