use sp_recompile which Causes this stored procedure to be recompiled the next time they are run.

Syntax

sp_recompile [ @objname = ] 'object'

Arguments

[@objname =] 'object'

Is the qualified or unqualified name of...

you said :

I created link (on their desktop) to a batch file (on the server) that copies the front end from the server to their local drive every time they...

I also see a script here in SqlserverCentral called sp_who3 ... it is very good .. search for it..

see this site for more help on replication

http://www.sqlservercentral.com/columnists/mkodli/sql2000replicationarchitecture.asp

I hope it help u

there are 2 thing to check

1- run regedit

and go to

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC

and change connectionTimeout to 300 for example (5 minutes)

note: 0 = unlimited

2-open EM, then from Tools menu...

of course the second method is more efficent ...

because in first method you may suffer from the LOCK problems .. if more than one connection open the same table

but sometimes...

open EM, then from Tools menu > choose options

then select andanced tab, and in login time out , make it more than 4 seconds ... (0 = unlimited)

I hope...

I think the best thing is to make try

{

}

catch();

and in this you can try to run the SQL cammand that you may write in in a text...

to link tables in Access ..

1- make a system DSN from Control Panel >> Administrative Tools >> Data Sources (ODBC) .. and make this System DSN refer to your Database...

also you can make a union query between these 2 tables in Access ... and make an insert query based on that Union Query ...

and insert the Data into...

please agan see that link ..

http://www.access-programmers.co.uk/forums/showthread.php?t=35365&highlight=Hang+Access+SQL+Server

because It will help u to solve to problems or locking between Accesss and SQL Server .. because Access cashes the whole table when you...

of course this is the best book :

"Microsoft Access Developer's Guide to SQL Server".

you must take care from Hanging Issue (Locking problem between Access and SQL Server) which cause...

I think the previous Transaction Log is very good ...

but if your Data is very important, then Backup transaction log every 20 or 30 minute.

Try to install SP3a for SQL Server ... and install MDAC 2.7 SP1 on the client machine and see what is happened

I hope this help u

this is the best book

"Microsoft Access Developer's Guide to SQL Server". its link is

http://www.amazon.com/exec/obidos/tg/detail/-/0672319446/103-0676301-1184601?v=glance

you must take care from Hanging Issue (Locking problem between Access and SQL Server)

see this link...