I have a form that is used by staff to input information which in turn writes the data to three related tables. Everything has been working great until yesterday afternoon when it locked up on only one of the tables. I have looked at everything I can think of to figure out why this is suddenly occuring. The same thing happens if I just run the query on it's own. The table that is locking is left joined to the main table. I can open and input directly to the table with no trouble. Anyone have any ideas of what I am overlooking here? Thanks for any help you can provide.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query Locks Fields from One Table
- Thread starter akaJW
- Start date
- Status
Similar threads
- Locked
- Question
