in the subreport properties are you passing in the parameters from the parent report or some other values?

Could use an expression

=FORMAT(Today(),"dd/MMMM/yyyy")

Can experiment with the string format, just remember that capital M is month and lower m is minutes.

Only thing I can think of is to do your initial load and a second load to a different DB.

Then to sync, load into that different DB and use something...

Why leave the data in access, do a one time import to sql then point the access front end at SQL instead?

Maybe this will help

http://www.sqlservercentral.com/articles/Tally+Table/70735/

Also provide the deadlock graph if you have it, if not enable traceflag 1222 or use extendend events or a WMI query to capture the deadlock graph.

Hi.

If you would be so kind as to read the second link in my signature on posting code, we would required DDL of the tables views indexes and sample data,...

14420 is no TX backup of primary database, I suggest fixing why you cant take TX backups of the primary DB.

(Edit, got my 14420 and 14421 errors the wrong way...

Could also be a kerberos issue is the SPN's havn't been setup to allow double hopping.

Take a look at BEGIN TRY along with a BEGIN CATCH aswell as @@Error

Could of been SQL injection, especially if your using sa as the apps login.

All they need to do is enabled xp_cmdshell and enter a Regini.exe command via xp_cmdshell to change...

Glad you got it back and working again.

Looks like you need to do some research on JOINS for starters.

http://www.sqlservercentral.com/stairway/75773/

What have you tried so far in getting your result?

whats the full error message from eventvwr?

17058 is usually cannot open a file, usually down to permission errors.