Change the Caption of a field in a tble

[spaLOGICng]

You seem to still think that a view cannot be updated using Access.

I never said that. I simply stated that a PK must be created on the linked Table (Access TDF), because in Access they are all called Tables even though we know the Link is to a View, before it can be update from Access,

I affirmed your statement that the PK is lost when the Table is refreshed. To cure that, I maintain a procedure to test and re-create the PKs when this happens.

But for the record, I use updateable VIEWS in Access all the time.

 

[spaLOGICng]

It is a pseudo index. It is NOT physical.

Hmmmm. Colin said it isn't lost. Guess I'll have to check.

Yes, any index on a linked table is a psuedo index. I don't think that is of concern here, but it is good to know that is how it is described.

As for losing the PK when the Table is refreshed, as I stated in my first comment on the topic, not when the Refresh method is used from the Popup menu on right mouse on the table. And now that I am testing other scenarios, the view that I am testing now is not losing it, but I know there are instances where it is lost. Apparently, we don't know the exact cause. I am using DSN-less connections. It is not doing it against my Server DB's, but it is doing it against one of my Client's DB several hundred miles away in St. Louis, with a DSN-less connection, and another in California. Interesting, Will investigate.

 

[spaLOGICng]

Once I figured out the index was being lost, I just used DDL to recreate it after the relink. I never tried to track down the reason. I just moved on. The first time i remember it happening was more than 20 years ago. I'm pretty sure it isn't getting fixed anytime soon.

That is where I am at now. Just knowing that it can happen and having a solution in place is how I have proceeded with it as well. There are likely many other quirks that we will never know the exact reason for them.