Perfect thanks. 🙂

Lynn Pettis (8/6/2009)

---

Okay, now we are actually getting somewhere. How about providing us with the actual problem you are trying to resolve? Rather than asking piecemeal questions, put...

[/quote]

>>Still not fully understanding what you are trying to accomplish.

Ok let me try again and thanks for working with me.

>>Other than the fact that July ends on 2009-07-31...

Lynn Pettis (8/6/2009)

---

A little confused as to what you are asking. Are you wanting the to return the last day of a month based on the current or given...

Perfect, thanks.

Your first thought is a good one. I ftp and delete the file 5 days a week but my file creation package runs every day and sure enough it failed...

This is the setup I have used with success. Particularly useful if the structure of your tables changes frequently.

http://www.accessmvp.com/djsteele/DSNLessLinks.html

I would also consider SSIS but if you want to continue to use access you can setup DSN-Less connections. http://support.microsoft.com/kb/892490

Thanks all, I would say this is resolved, backup times have been greatly reduced by backing up to a different array of disks on the SAN.

>>You are much better off backing up to a local OS drive, on the SAN or not, and then running a file copy.

This is the direction I would like to...