Ashley,
Check two things. First, make sure that your connection isn't set for asynchronous operation. Next, make sure that the FetchSize for all your views is -1 (fetch all records). If you're using the view designer you can find that option by choosing Advanced Options from the Query menu.
>I have a application that populates several old Access 2.0 tables, some of the tables are being populated properly but every time I do an Insert and a TableUpdate() at a particular point I keep getting a "Connection is Busy" error.
>
>I have tried adding delays into the code so that the previous updates have plenty of time to get through but still no joy.
>
>Any ideas?
>
>Ashley Cottle
>AssureSoft Ltd
>Cheltenham
>England
>
>
>
AshleyC@cosworth.infotrade.co.uk