Make Table Query in NEW ACCESS file

V

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.
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Table Query to external ODBC SQL Server database 17
Make table query: [Enter 1] AS Test 1
Make Table Query 1
make-table 1
make table query 3
Make-table query with around 2 ml records taking too long 0
Make Table Query 1
Make-Table Query Destroys the Wrong Table 2

Top