Results 1 to 9 of 9
  1. #1
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740

    Unanswered: linked XLS - did something change?

    i update a linked XLS from access using INSERT sql and currentdb.execute

    this has been working for the past 7 years.
    today it failed.
    my XLS is no longer appendable.

    experiment:

    new XLS
    Name, Size
    Fred, 2
    Sue, 3

    new MDB
    file/get external data/link ...to the experimental XLS
    open the linked "table"
    ...can you add a new record?
    me=no

    did something change?

    izy
    currently using SS 2008R2

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    What did you update it to? If you updated it to Access 2007 then yes, lots changed and stuff that used to work will be producing new errors because Microsoft added a lot of new errors to the new version and removed quite a bit of nice features at the same time to give us the new "up"dated version.

    If you didn't change the version, perhaps something changed at the spreadsheet side? Look at what you changed carefully during your update too... obvious, but sometimes we overlook the ramifications of making minor changes...
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    thanks 'Trekker,

    this is still Access 2003/Excel 2003 with zero voluntary updates since the code last ran 21st January (...but ManageSoft is there to "help" me with involuntary updates so i have no idea what happened inside my machine the past 2 months).

    appending to linked XLS is not something i normally do - am i right in thinking that it SHOULD work?
    ...or at least that it USED to work?

    i tried the experiment with simple two-row XLS, link, open linked on two of my colleagues' machine ...not append-able.

    izy
    currently using SS 2008R2

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    mystery explained - apparently this behaviour is now to be accepted as "normal"!
    thanks Bill.

    this app only runs once a quarter and after some digging around in the data it looks like the append was not needed/called in the recent runs.

    ho hum - at least it provides an incentive to re-write the app properly without the linked XLS

    izy
    currently using SS 2008R2

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    It wasn't entirely Bill's fault. I believe this change instigaged in a Service Pack (2) and was based on MSAccess using a technique which was similar (or a concept) to that created by "Some guy called Carlos Armando (a Guatemalan man)." (I actually don't think he even did ANY coding to do this (but I've read different stories on this) versus just patenting the "idea" or coming up with a way of doing it!) From what I recall in reading it in the MSAccess magazine about 5-10 years ago, this guy tried to sell Microsoft his idea on this, then quickly patented the idea and sued Microsoft for big bucks when they implimented it and although there was a settllement, he still refused to let Microsoft use his idea and required it be removed in Microsoft's next Service Pack (since he was most likely anti-Microsoft when they kicked him and his idea out their door). So I would say thanks to this guy who got rich but had to be an ass about not letting Microsoft use his idea. But Microsoft was getting a lot of heat back then for ideas that they DID steal from others and they probably did "steal" his idea and not give him credit (typical Microsoft). But also, sooner or later someone would have sent Microsoft an email saying "Could you make MSAccess and Excel do this?" We most likely wouldn't have run out and patented the idea though to use against Microsoft and that feature would most likely still be in MSAccess/Excel. Thanks again Carlos - you've made things difficult for a lot of us simply on principle alone (hope he enjoys his mansion.) I believe it was Service Pack 2.

    Lesson learned: Go out and patent every idea you can on how to improve Microsoft products and then simply sue them to get rich when they impliment them. While you're at it, think of every improvement you could patent for cars and other products. Hopefully the rules on this kind of patenting have changed though.

    Ask your network geeks and I bet they most likely recently applied Service Pack 2. It's too bad Microsoft couldn't have argued to have this change as a stand-alone Service Pack (as an option for just the Access-Excel part).

    Here's a couple of articles I found on it:
    http://www.computerwire.com/industri...3-65CDA597DD1A
    http://gen-eric.com/patents/index.ph...data_linking_t
    http://www.out-law.com/page-5712
    http://www.news.com/Microsoft-sued-o...3-5711195.html
    and an interesting one: http://techdirt.com/blog.php?tag=carlos+armando+amado

    8.6 million is what good old Carlos got.

    To me it's crap. Lots of us have created techniques or had ideas USING the Microsoft products on how to improve them but we don't go around trying to sell our ideas to Microsoft and then patenting those ideas so we can then sue Microsoft should they embed that routine in their next version. Even if they did, sure I'd perhaps like a little money (not 500 million which I believe was the original lawsuit - an obviously overly-GREEDY amount in my mind) and the credit (and might want a little money depending on what exactly it is). But I sure as heck wouldn't make everyone's life miserable by forcing Microsoft to remove the technque - that's just plain evil and what bugs me the most about Carlos and his role in this. There's probably many other developers still out there who are in for a surprise when Service Pack 2 is installed. I have to admit though, it changed the policy at the company I worked at where the network guys would just install Service Packs without consulting me. I hope it does the same for you Izy. After our incidient, I started getting emails from the network guys "we were thinking of installing Service Pack X - is there anything which might affect your coding with this?"

    (In my opinion (and some of you will probably disagree) - that we all sue Carlos for the misery he's caused from forcing Microsoft to remove this feature and causing us headaches and get him to distribute his 8.6 million he actually got to each of us (for the time we've spent on finding work-arounds) and make him a poor man!) Maybe those are a little too much harsh words (or for some, maybe not harsh enough.)

    I only wish Izy's link to the Microsoft website that Microsoft would have stated something to this effect on their site "Specifically because of this guy (Carlos Armando, his address, and his email)...you no longer have this feature!"

    But I'm going to be careful here as there may be different opinions on this. Sorry but this is one of those things that has really bugged me over the years and cost me many hours of development time after the Service Pack was installed.
    Last edited by pkstormy; 03-14-08 at 09:15.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Interesting. Thanks PK
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    [withdrawn]thanks Bill[/withdrawn]
    thanks for the clarif PK: we certainly need more people like Carlos in the world.

    izy
    currently using SS 2008R2

  8. #8
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    If only I had his Carlos's address. I might thank him in my own "special" way. What seems strange is that I used to have a lot of different web articles on this which seem to be mysteriously vanishing off the web. I wonder if some people tracked this guy down and he got to much hate mail and something happened.
    Last edited by pkstormy; 03-14-08 at 14:36.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Probably made enough $ to retire ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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