Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Cannot open database “. It may not be a database...
1 view
Skip to first unread message
GadiLevy
Aug 29, 2007, 10:12:03 PM8/29/07
to
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?
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
Aug 29, 2007, 10:52:10 PM8/29/07
to
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
Aug 29, 2007, 11:10:03 PM8/29/07
to
The database size is 2gig.
Is the solution to run it in a new database just for that table?
Gadi
Is the solution to run it in a new database just for that table?
Gadi
John W. Vinson
Aug 30, 2007, 12:32:37 AM8/30/07
to
On Wed, 29 Aug 2007 20:10:03 -0700, GadiLevy
<Gadi...@discussions.microsoft.com> wrote:
<Gadi...@discussions.microsoft.com> wrote:
>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]
0 new messages