update, append query Joins being deleted.

[Pete]

After realizing the integrity of my data is questionable I went back to
my update queries and opened up a few. The joins I had originally
created between key fields were no longer there. It was as if someone
when in and deleted them. I have been using Access for 10 years and
I've never seen such a thing. My temporary solution is to embed my
update queries in vb as a SQL string. That way I know the SQL will not
get modified. More and more I'm loosing trust in these query objects
this is the second time in 4 months I saw this happen. If anyone has
ever seen this please let me know. Thanks.

[Salad]

Pete wrote:

After realizing the integrity of my data is questionable I went back to
my update queries and opened up a few. The joins I had originally
created between key fields were no longer there. It was as if someone
when in and deleted them. I have been using Access for 10 years and
I've never seen such a thing. My temporary solution is to embed my
update queries in vb as a SQL string. That way I know the SQL will not
get modified. More and more I'm loosing trust in these query objects
this is the second time in 4 months I saw this happen. If anyone has
ever seen this please let me know. Thanks.

Did you look at the LastModifiedDate? Were they modified around the
time YOU modified them or when SOMEONE else modified them.

Now, here's another situation. You create WonderfulQuery and put it in
as a form or reports recordsource. You now decide to modify the
recordsource a tad. You "really" didn't need this or that table and cut
them out, and saved it. You actually modified the query, not only the
recordsource.

[Pete]

Salad wrote:

Did you look at the LastModifiedDate? Were they modified around the
time YOU modified them or when SOMEONE else modified them.

Now, here's another situation. You create WonderfulQuery and put it in
as a form or reports recordsource. You now decide to modify the
recordsource a tad. You "really" didn't need this or that table and cut
them out, and saved it. You actually modified the query, not only the
recordsource.

theoretically I've locked everyone out of the database using an .mdw
security file and I've tested that and it works. No one else even
knows about this admin utility. It just has a bunch of action queries
not embedded form queries. The only conclusion I can draw from this is
not to trust joins in queries unless you have created one-to-one or
many joins with primary keys. Maybe delete or relinking the tables has
an effect on the queries in the database and it deletes the joins but
retains the tables. Has anyone else seen that?