Error on Make Table Query

[DaveC]

Using ACCESS 2010 -



I have a linked table that I want to query a portion of into a new table. The link is fine and I can select the data that I'm looking for. However when I run the make table query I get this error:

Cannot open database ". It may not be a database that your application recognizes, or the file may be corrupt.

I'm trying to create the table within the same database as the query. I have no idea where the quotation mark (should be the database name) is coming from. Anybody seen this before?

Thanks

[burrina]

Take a look at this link. http://answers.microsoft.com/en-us/o...f-919dace97dff

HTH

[June7]

Recommend you not build MakeTable query as part of db design.

Create the table and then do APPEND (INSERT) actions.

Why do you need to duplicate the data into a local table?

[DaveC]

It appears that the make table will exceed the 2 GB limit, and that's what the error is really about (thanks for the link burrina). Though the error message is rather obscure.

I need to create local tables because our old Oracle server is being shut down and I want to archive the data. I'll have to split the big table into multiple MDB files to keep each one below 2GB.

[June7]

Consider SQLServer Express. I think it is now 10GB size limit and it is free.