What happens if you drop/re-link it?

You can do it.  Database options for SQL 2K are for SQL 6.0 to present.  Of course like Gift stated there may be gotchas.

If possible you could script the items...

The only file you would be able to access is the MDB.  The LDB basically is there to let the system know it is currently opened by someone/something.

Can you open...

Ok here goes.

1.  '' = empty string, NULL is the ABSENCE of everything and is generally NOT a good idea to use. (There are REAMS of documentation on both fronts... ...

Ok.

1.  Unless you are setting multiple items with the same statement STOP using SELECT.  USE SET instead.  i.e SET @thisMonth = DATEPART(month, @testDate) - 1

2.  Why do 2 different calls...

SQL server and using compressed data is not a good idea.  Granted you can use Windows compression to manage your disk space HOWEVER, everytime the system needs to access the...

Try researching DATEPART(quarter, DATEx) in BOL....

AFAIK up until W2K3 the O?S would not use it.  So unless you are on Windows 2K3 it won't do anything but, possibly slow you down.

Have you searched this site for information?  This is a frequently asked question and there are several EXCELLENT ways of doing this already posted....

Assumption:  You are attempting to edit a table with EM.  Does the table have a PK?  If NO then this will probably not work..  Can you do this via a...

OR you could use the import/export wizard OR a DTS package with copy objects OR ....

OR...

You could figure out the MONTH difference and divide by 12 ie.

SELECT datediff(MONTH, convert(datetime, '2004-12-31', 120), convert(datetime, '2005-01-01', 120)) / 12

SELECT datediff(MONTH, convert(datetime, '2004-01-01', 120), convert(datetime, '2005-12-31', 120)) / 12

I would research FORMAT() and you will need to CONCATENATE the field parts possibly.  Something like FORMAT(YYYYMMDD, ColumnDate)

To perform what function?

Another item to look at (from what I can tell) is that the 1st couple of joined tables you have not defined the joins.  This can lead to performance problems...