Cannot open database “. It may not be a database...

[GadiLevy]

Running the query using two tables result in over 5,000,000 records. when I
try to make table I get the massage: Cannot open database “. It may not be a
database that your application recognizes, or the file may be corrupt.
If I run a much smaller version of that query I have no problems.
What could be the cause of it?

 

[John W. Vinson]

Running the query using two tables result in over 5,000,000 records. when I
try to make table I get the massage: Cannot open database “. It may not be a
database that your application recognizes, or the file may be corrupt.
If I run a much smaller version of that query I have no problems.
What could be the cause of it?

Are these tables in Microsoft Access? If so, how large is the .mdb or .mde
file containing these tables? If it exceeds 2 GByte you're likely to get error
messages like this... I hope you have a backup!

What query are you trying to run!? Sounds like a Cartesian join that's gotten
out of hand!

John W. Vinson [MVP]

 

[GadiLevy]

The database size is 2gig.
Is the solution to run it in a new database just for that table?
Gadi

 

[John W. Vinson]

The database size is 2gig.
Is the solution to run it in a new database just for that table?
Gadi

I'll have to read your other post. I don't think it's a good idea to create
this table in Access in the first place!

If you must, then yes, use a separate freshly compacted .mdb file for this
table alone.

John W. Vinson [MVP]