Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Updateable Query (Access 2003 / Excel 2003)

    I have a database that is connected to several Excel worksheets in a workbook.
    Up until today I have been able to run queries that would update the data on these worksheets.

    Is there a setting in Access that would cause these worksheet update queries to suddenly decide they
    are no longer updateable queries?

    I have been using this database for over two years. The queries have updated the worksheets with no
    issues until today. All of the sudden today they decide the query is not updateable.

    Any ideas.


    Thanks
    Richard

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Updateable Query (Access 2003 / Excel 2003)

    Did you happen to be behind with installing updates until now? The ability to update data in linked Excel tables from Access has been taken away over 2 years ago "because of legal issues" - see You cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2007, Office Access 2003, or Access 2002.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updateable Query (Access 2003 / Excel 2003)

    Is ther any way to tell when the service pack was loaded?
    I checked the Help / About and we are now useing Access 2003 SP3.

    Thanks for you help
    Richard

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Updateable Query (Access 2003 / Excel 2003)

    Updating linked Excel tables was disabled in Access 2003 SP2, so if you have SP3 it is definitely disabled.

    If you use Microsoft Update, you can go to the website and view your installation history.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updateable Query (Access 2003 / Excel 2003)

    Thanks Hans
    Richard

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updateable Query (Access 2003 / Excel 2003)

    I have looked but can not seem to find when SP3 was released.
    Do you have a date for that SP release?


    Thanks
    Richard

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Updateable Query (Access 2003 / Excel 2003)

    According to Description of Office 2003 Service Pack 3 it was September 18, 2007.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •