Hi thanks SS Coach. Thought as much.

It's clinical trials data.

Hi - thanks

where do I run Sys.dm_db_index_physical_stats from the sys DB or any DB ?

Re: MS recommendations for DB maintenance - can anyone point me to any ?

Hi thanks

Is there something I can use quickly that will give me info on what state the tables/indexes are in ?

I'm coming from a DB2 background so don't know SS...

Hi thanks SScoach

I can't see anywhere connectionsstrings.com where it gives a connection string from to query a linked SQL table in access

Hi

any help forthcoming ?

Hi - thanks for the prompt(!) reply.

Yes I didn;t ask about windows authentication. So really we could add the user that is running the vb script as a windows authenticated...