RE: Make Table Query in NEW ACCESS file

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Vadhimoo" wrote:

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.

.

Relevant Pages

  • Re: Database Results Wizard Error Message
    ... > I would any other access file with ASP pages. ... > SQL statement to query the file. ... >> database when you get this error. ...
    (microsoft.public.frontpage.client)
  • Re: Open a Microsoft Access file from within Word
    ... I used the GetObject function like the help says and I don't get any ... but the access file does not open (I also tried it with an Excel file ... the information in the Access database has nothing to do with the ... Word document, I am not inputting data from the Word document into the Access ...
    (microsoft.public.word.vba.general)
  • Re: Linking Access databases (Jet SQL)
    ... >Access file, using this syntax: ... the external table in the database which contains the query (primary ... Then you open the primary database with a System.mdb file ...
    (borland.public.delphi.database.ado)
  • Re: Access 2003 missing the intranet or the website
    ... If you can't successfully convert your Microsoft Access file by pointing ... to Database Utilities on the Tools menu and then clicking the Convert ... or Access project (Microsoft Access project: ...
    (comp.databases.ms-access)
  • Re: Getting tasks from Access database
    ... standalone application or Add-in from Outlook, ... Open your access database file ... iterate steps 4 through 6 for all the records in your access file. ... I am an experienced VB programmer but have done very little programming in Outlook itself. ...
    (microsoft.public.outlook.interop)