Intermittent Query Failure

[jayde]

I am working on a small Win 2000 network (10 users)on a workstation running Win 2000 Professional. The application uses an Access 2000 frontend and a SQL Server 7 database with all of the available service packs. I use a form to locate records in the database based on Name, Organization or Postal Code. When the user enters search text and presses enter/tab the code changes the recordset to a query that references the form field.

This had been working correctly for a long time. Recently it has been failing intermittently. Once it fails, if I close and reopen the frontend it works again. After a search fails I can still go into the linked table in the frontend and fine the record manually. This behavior has occurred with both new and old records. I am essentially clueless about what would cause occasional failure. I am using standard Access Queries not PassThrough SQL Queries.

So far I have tried the following:

I have rewritten the queries referenced in the code.
Used the Link Table Manager to refresh all of my links.
Used Repair and Compress Utility
Exported everything in the database into an empty database to try remove any corruption that the utility failed to fix.
Deleted and rebuilt the SQL indexes

Any suggestions would be welcome. I am stumped and the client is not happy.

Thanks,



\ \ \ | | / / /
[---O-O---]
\ (_) /
{{{-}}}

--OooO--OooO---

Jayde Donnelly