Odd issue, but thanks for posting

1)There is no difference between a view and a simple select for performance.

Beware of making views based upon views ->effect performance (possible to much data joined)

2)Views usually haven't and don't need...

1) take a backup of the current version

2)Try compacting & repairing in Access + recompile the code

3)See if everything got back to normal

4)Try decompiling your vba modules (start Access with...

This asks for a normalisation of the database. http://www.tutorialized.com/tutorial/Normalisation/7433

This is because you rely on implicit conversion between varchar and datetime

by default convert/cast use the mon dd yyyy hh:miAM format

when casting datetime to varchar

1) the EXEC sp_executeSql @SqlString

can be dropped, no need for dynamic sql here

2)There can be a few inner joins

3) The owner of the tables should be specified for better performance

SELECT...

What method/program you use to connect to your MSDE server?

1)Always gives the fields a name instead of using SELECT *

INSERT INTO dbo.ORDERS

(Id_record, Id_title, Customer, Order_ID)

SELECT Id_record, Id_title, Customer, @random

FROM dbo.Cart CART

WHERE Cart.Customer = @user

The query analyzer can script...

You indeed have to update the client tools of who connects to sql server sp4.

CREATE TRIGGER TR_ASSIGNMENT_INSERT on dbo.Assignment

FOR INSERT,UPDATE

AS

SET NOCOUNT ON

UPDATE dbo.Workorder

SET user=INSERTED.USER /*INSERTED CONTAINS NEW OR CHANGED DATA*/

FROM dbo.Workorder Workorder

inner join INSERTED /*LINK WITH WORKORDER*/

ON INSERTED.WorkorderID=Workorder.ID

Not totally sure but how are the sql servers registered on her enterprise manager (edit registration)

1)Display SQL Server state is on?

Perhaps EM tries to log in to verify the current...

I would see the book online for that topic.

If there was a large transaction going on ( like altering a table in enterprise manager) it will be rolled back (...

1)Is there any application active on the server except Windows 2003 and sql server? (Antivirus, IIS,...)

2) Ms full search is enabled?

1) Does it have a lot of recovering (rolling forward transactions) to do (see sql server logs)

2) It might be because of the tempdb is growing to its initial size

3) Anything...

I wouldn't expect any problems leaving compatibility at 80, because there aren't major differences between sql server 7 and sql server 2000.

In 2000 they added user defined functions,changable collations and better...