Make Table Query in NEW ACCESS file

[Vadhimoo]

Dear All,

Good Evening, Most of the time my access file size is exceed 2GB size and
aftef that i cant able to use MAKE Table Query. It says the error message "
Invalid Argument". Then i wiil create one new access file then use the make
table query from my old access file using "Another Database" option.
Is there any query is available to Create a NEW ms acess file and use the
MAKE TABLE query from old Access file.

For Example:
Jan2008.mdb is my old access file . I want to write query from Jan2008.mdb
and that query should create a new access file (Feb2008) and create a table
in that.

please help me in this issue.

Have a Nice Week End..!

Regards,
Vadhimoo.

 

[Jerry Whittle]

This is one time I agree with Aaron K. You seriously need to upsize to
another database like SQL Server, Oracle, or MySQL. If you have a new 2GB
database file each month, Access is not the right tool for your job.