Did all of your windows updates apply correctly after reboot?

Asynchronous Common Language Runtime Stored Procedure

You would need to create a manged stored proc which makes asynchronous calls to the database, each of them containing one of the queries.

Another...

1. Any number of reasons. (eg, network, disk, authentication, etc.)

2. Several methods. Easiest is probably via ssms, right click on the database you are concerned with and check last database...

Content removed because I misread a statement before answering.

Not only is shrinking just to let it grow again a waste of time and effort, it is also BAD. It leads to performance degradation and file fragmentation.

Perhaps also consider using SQL 2008 with compatibility mode 80. You don't get full SQl 2008 functionality, but you can get some improvements over sql 2000, with much less risk...

How did you create the tables?

Yes, changing the fillfactor will help. But I would make an argument that a clustered index probably shouldn't be used on an identity field at all. There are few exceptions,...

If you don't want to write update statements as indicated above, you have a couple of other options.

1. You can modify the forms in access so that they do not...

To be honest, I didn't disgest your code in its entirety. But from a strictly philosophical standpoint, if you want to make it faster, consider moving it to C#. Also,...

1. How is the data imported/exported from SQL to access and vice versa?

2. How is the access database designed? Are there multiple forms which all use the checkboxes?

I have resolved the issue. Processmon identified what appeared to be several bad registry entries. I ran a repair installation and rebooted. (also replaced that .dll, manually, for good measure.)...

1. Are both builds of SQL the same?

2. Do the execution plans look the same?

3. How are you comparing response times between the two systems?