very helpful.  We'd like to run this delete once or twice a year over a weekend.

I'm thinking the best choice may be to script the indexes for all the tables,...

Good idea, But we use a moderately complex select to discover the rows to delete and the tables will have millions of rows after the deletion is performed.

Next?

Thanks for all your help.  Here is a version that works.  I decided to count the rows that match.  In a perfect world, it would only display results where the...

This almost works:

Declare @tablename varchar(255)

Declare tablecursor CURSOR For

  Select TABLE_NAME from INFORMATION_SCHEMA.COLUMNS

    WHERE COLUMN_NAME = 'QTY_PO'

OPEN tablecursor

FETCH NEXT from tablecursor into @tablename

while @@fetch_status = 0

  BEGIN

   print @tablename

   select QTY_PO...

Thanks for the Quick excellent response. 

Here is another Haiku in gratitude.

A Phoenix arose

from my grandfather's ashes

"Got a light?", it said

Not being a wiz at running stored procedures and figuring out the correct parameters, I used Steve's idea.  It reassignes the owner to the current user's account.  Seems to do...

Sorry that wasn't really necessary.  Excuse the space.

That works, but I need a 2 digit year in front. 

The Mdac version was the problem. When I updated to 2.7 SP1 Refresh, the problem vanished.

Midnight on the bridge

Icy wind and yellow moon

rising. No wetsuit.

Directly on the server means running the 40 pages of select statements in query analyzer on the server. Mdac version is 7.6 sp2.

Yes we use an instance name. The...

Thanks for the great response.

Midnight on the bridge

Icy wind and yellow moon

rising. No wetsuit.

ok Thanks for all your help. That code was very interesting.

spring, summer, fall now

dawn breaks on cold, white magic

Winter's chill is nigh

Can this be converted to a function? That would involve replacing the sp_executesql statement with an xp_ statement.

spring, summer, fall now

dawn breaks on cold, white magic

Winter's chill is nigh

Solution:

Even though the Access database was secured using the default MDW file, I had to grant read access rights to the Access tables using the Admin id.

This solved...

I double checked that. The error message remains the same. Perhaps I am using the wrong driver?

spring, summer, fall now

dawn breaks on cold, white magic

Winter's chill is nigh