I would drop and recreate those indexes. No need for anything  like DBCC DBREPAIR !

LADP is the right way and yes you can use it for that. Have a look at:

http://msdn.microsoft.com/library/en-us/adsi/adsi/distributed_query.asp?frame=true

http://support.microsoft.com/default.aspx?scid=kb;en-us;299410

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/distributed_query.asp

Now if you can't use it because you still don't have...

Distributed transactions on a trigger is a "no-no". If the Trigger fails i has to rollback an distributed and a local transaction and on top of that KILL the batch...

dbrecover???? Is that a custom procedure?

Definitely not something built-int!

And to keep adding wood to fire ALL DW implementation (That I have dealt with) use surrogate Identity Keys, can you guess why?

The answer is to use either Local Access Tables or Unbound forms with vb Classes.

You are goin to have probles if you try bound forms with Linked SQL Tables this Topic...

sp_updatestats is good when you need something for ALL tables,

the UPDATE STATISTICS gives you finer control (Just the one you need )

and BTW

Maintenance...

Ok what is happening is that the auto create statistics process can't catch up with the amount of changes.

You must schedule :

UPDATE STATISTICS ( WITH FULLSCAN) at off hours to compensate for that!

how...

Yes I agree with this part:

They produce different result times based on the distribution of the Initial Set of Numbers

The part I was differing with was:

which you...

2 Questions.

1. Do you have the DB with auto create statistics on!

2. Does the Base Table  of that view change very often ? (lots od DML on it)

breadth-first or deph-first they have the same cost. They produce different result times based on the distribution of the Initial Set of Numbers which you can't control

I tend to differ...

OR:

-- create table Suppliers( SUPPLIER char(5),PRODUCT varchar(5),QTY_IN_STOCK int)

--

--

--

--

-- insert into Suppliers (SUPPLIER, PRODUCT, QTY_IN_STOCK) values('SUPP1', 'a1' , 5)

-- insert into Suppliers (SUPPLIER, PRODUCT, QTY_IN_STOCK) values('SUPP1', 'a2'...

Tough question.

Make sure you understand how MS ACCESS works

Minimize the records you pulldown to Access

Separate the jobs that can be done better in the server from those that can be...

yor problem is syntax:

try:

For i = 1 To 12

    Me.Controls("unit" & i).locked = (Un <= i) 

Next i

It has always been docummented

From BOL:

Syntax

CREATE PROC [ EDURE ] [ owner. ] procedure_name [ ; number ]

[ {...