Hi All,
Please excuse the cross-post, I accidentally put this in the FORMS forum.
I have a user who creates some fairly complex views in an Access 2k ADP (residing on a Win2k desktop accessing a Sql Server db running on a Win2k server). She's having an intermittent problem with the views becoming corrupted. She'll build a view and get it working, then upon returning to that view to make changes, the designer no longer shows, just the SQL. Most times the SQL is still good, but sometimes it's only partially there (not truncated, but pieces in the middle missing).
I can see the SQL fine in Sql Server Query Analyzer, but Access 2k can no longer interpret the SQL to show it in designer.
This is not isolated to her desktop machine, it happens on mine as well.
Has anyone else experienced this, and have you found a solution? I've searched the MS Knowledge base with no luck. She has the latest patches on her desktop.
Thanks for your help,
Bill
Please excuse the cross-post, I accidentally put this in the FORMS forum.
I have a user who creates some fairly complex views in an Access 2k ADP (residing on a Win2k desktop accessing a Sql Server db running on a Win2k server). She's having an intermittent problem with the views becoming corrupted. She'll build a view and get it working, then upon returning to that view to make changes, the designer no longer shows, just the SQL. Most times the SQL is still good, but sometimes it's only partially there (not truncated, but pieces in the middle missing).
I can see the SQL fine in Sql Server Query Analyzer, but Access 2k can no longer interpret the SQL to show it in designer.
This is not isolated to her desktop machine, it happens on mine as well.
Has anyone else experienced this, and have you found a solution? I've searched the MS Knowledge base with no luck. She has the latest patches on her desktop.
Thanks for your help,
Bill