Without knowing more about how your clients access data I will assume(bad I know ;)) that your clients only need to read data, if this is true then you want...

Since your dealing with an ACCESS databases have you tried using the compact and repair function?

Check MSDN for corruption ACCESS Database

Here is what I found that could be useful.

http://support.microsoft.com/kb/279334/

Since your using SQL 2005 CE why not use Merge Replication?

Lol, Loner dont fret I dont think I have gotten 1 QoTD right but I do like to do the research to find out the answer.

I agree with...

You should check BOL for the words LEFT OUTER JOIN and COALESCE.

If you dont like looking up references (heaven forbid!) then:

LEFT OUTER JOIN is to return ALL values from the...