VBA doesn't handle files larger than 2gb, which is one of the reasons people don't recommend using Excel and Access for your business. There are some ways to deal with the 2gb limit[1], but it is better to use other software.

[1] http://support.microsoft.com/kb/189981