That part about it having to be a Fox2X table is definately strange! If you start with a new SYSINFO table that you build from scratch, does it still behave this way?
>I'm sorry if I've confused matters. I've developed a framework that uses views exclusively to access local tables (all free tables) or data stored in SQL server. It's become my new religion to never-ever open a table directly. Every one of my forms is free of any tables or views when it loads - all views are added from meta-data when the form loads - I even create my view DBC on the fly.
>
>I checked my underlying SYSINFO.DBF table in the debugger and it reports a buffermode of 0 (none). Hmmm... Everything works FINE if:
>
>a) I close the underlying table (that the view opened originally) right before I call the TableUpdate()
>
>b) Change the type of table to FOX2X (you can't *make* me go back there..)
>
>I have a view object that I use for all data access (think of a half-baked cursor adapter). After every requery() and before every PUT() I simply issue a USE IN SELECT("SourceTable"). That forces the view to re-open it's source fIt works, but I don't like it. I'll try to post some repro code over the weekend - this really shouldn't be happening.
>
>Thanks for your time and tenacity!
>
>Best Regards,