Mandy ---

Ack!!! Don't do that.

Do the following: Run GENDBC against your new database container. Then edit the resulting PRG and cut out the CREATE SQL and DBSETPROP statements applicable to the changed views into another PRG. Create a small EXE out of the PRG and distribute that. Have the users run it.



>
>I was having some problems with some views which had gotten out of synch. If I open my database and recreate them (with createsql commands), all is fine.
>
>I have already distributed an app with data files to a number of users. I've tested the following idea out to send them the fix for the above problem, but thought I'd check with you before sending this out to the masses.
>
>If I open my copy of the database which I sent to a user, rerun the createsql commands on it to recreate (thus fix) the problem views (just two), can I then send the users just the newly created three .DCT,.DBC, & .DCX files and have them overwrite their existing three files with these? Will this affect any of the other links the D?? files have on other views and tables?
>
>Many thanks!
>
>Mandy