Appending to Linked Table

[DBFIN]

I have a table in MS Access 2010 that is a link to an external data file in .csv format. I assumed that it was not possible to append data to a linked table until recently. I appended 3 records to the linked table and discovered that the 3 records were appended to the table and the external data file it was linked to.

I thought this was not possible ? What am I missing ?

 

[pbaldy]

You're thinking of them as 2 separate tables; they're not. The linked table is like a window on the external table. The data only exists there.

 

[Galaxiom]

Linked Text files can be appended to.

Can't delete lines or edit

 

[DBFIN]

I have one final question. I have been trying to understand this for quite some time. I always get outstanding responses from MS Access World Forum and greatly appreciate the Forum. What is the incentive for members to provide such outstanding expertise. I ask this question respectfully simply because I am a very inquisitive indiviual. Are many of the members Microsoft employees? Does this help Microsoft learn of any software limitations so that they can upgrade the Microsoft software ? Are all these members good samaritans ? I truthfully don't know the answer to this and ask respectfully.

 

[pbaldy]

I can only think of one MS employee that posts here offhand. Speaking for myself, it's a combination of paying back help I got early on, learning more, and I just enjoying helping others learn.

 

[DBFIN]

This is fantastic. I always believe that progress lies in the hands of the good and wise. The members of the MS Access Forum are all very wise samaratans and I am extremely grateful for all your help. I mean this with the utmost sincerety.

 

[pbaldy]

Happy to help!

 

[Galaxiom]

I joined after so many Google searches for Access information turned up here. I asked questions I could not find answers for and started reading through the questions that sounded interesting. Doing this I regularly found things I hadn't been aware about.

Then I answered some of the simple ones partly out of wanting to contribute something back, partly so the question would get a quick answer and partly to save the gurus from the trivial questions.

Sometimes I took on more than I really knew. Invariably if I said something less than ideal one of the more experienced members would pick it up and explain best practice which was great for me as well as the memebr who asked the question.

As my own work progressed I found myself being one of the more knowledgeable members in some specialised areas that I had researched intensely for my own needs. By contributing on these subjects I found I could gain further experience with the feedback I got from those who used my suggestions. That would then prompt me to research even more.

I will always look at any questions that involve Active Directory searches, implementing digital signatures or WMI interactions.

There is also an aspect of honing my ability so that I can answer things of the top of my head. It helps keep me fluent in the syntax on things I would otherwise only use very occasionally and either forget exist or have to read up on every time I used them.

So for me it really is as much learning as helping as well as staying sharp on the bigger picture.

I will still shoot a quick answer back on simple things sometimes but now I am more inclined to leave them to the other new members who are going through the same enthusiastic learning phase I did.

And can see why the advanced members appear from nowhere as required to add their expert knowledge. After monitoring the new contributors for a bit I get to know who will be handling particular questions entirely competently and don't even bother to look at what they suggest.

And even now I still learn new techniques from time to time.

 

[DBFIN]

This is a win win for everyone. I think the MS Access Forum is fantastic as well as the members that contribute. Thanks again !!!