Chris...please could you elaborate? I'm not exactly sure what you mean...

Alan

Thanks for the suggestions.

Wrapping each UPDATE statement in a BEGIN TRANSACTION..COMMIT block has made a huge improvement.

Cheers!

Alan

Thanks guys! Some good advice here.

As Robert suggests, I'm going to break it down to see which part is slowest.

Alan

Thanks guys.

I can't restrict the number of rows because the table is dropped, re-created and populated at the start of the process. The updates then add keys by joining...

WOW!

Getting my head round this now..........

Thanks!

Alan

That's very true.

Alan

Thanks guys! This is all useful stuff!

Alan

Thanks Steve!

That is an EXTREMELY useful tip!

Alan

Thanks guys!

I totally understand that it's better from a support/maintenance point of view. I was mainly interested in whether listing column names makes a...

Thanks for the suggestions guys!

Restricting access seems to be a complex issue, so I'm going to use the table/index renaming idea suggested above. It's...

Presumably whatever approach you take to renew the data (truncate/insert, copy database/table, replication etc.) it's dependant on dropping connections that would get in the way.

Thanks for your quick replies!

Thanks guys.

It's going to be easier to create polling jobs that monitor about 6 receiving directories.

If I attempt to change the 30 or so packages that process the data daily,...

Am I right in thinking that MS Access will always pull the total contents of a table to a client machine before querying? Is this true of all versions? Can...

Presumably you could also use your existing MS Access forms/queries and have them source data from SQL Server 2005 instead of MS Access tables.

I'm working on a project to encourage...

Thanks for the advice, guys.

I think I understand the functionality/security issues now.

Is there a limit as to how big an Access database should...