Also, remember to close all connections and recordsets to avoid leaving orphaned connections. Close before setting to nothing.

Sorry, I was a little misleading when I said datagrid. What I meant is the data sheet view in an access form, I.e. you can bind a form, or certain...

Basically you can take a bespoke approach or take more time and go generic.

The steps are simple but note that if you want to display the data grid control with...

Thanks... I wiped the system and started again, will take a look when it’s rebuilt.

Also... both installs are updated to SP2. Running the same stored procedure on both and printing out timings shows each step as being slower by almost the same percentage as...

Just as an aside... linked tables and bound forms etc. are really slow, you might want to look at using ado instead, more code but much faster.

For anyone who gets the same issue:

It appears that when you paste into an Access 2007 text box you retain some of the formatting tags that normally get stripped when...

Looks like this is something to do with how wingding characters are handled when copied from an email into an Access text box. The main cause seems to be the...

The update is of course parameterised. The issue only occurs on some machines (possibly all 2007, haven't proved it though).

Cheers

We had a requirement recently to monitor not just database size, but application folders, i.e. a folder structure containing a combination of sql database files, temp import files, templates, output...