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

I get the below message in access all the time and do not know what causes it.  I can run a Create Table Query several times(replacing the previous table of the same name) without issue then all of the sudden i get the message.  and the only way i can get around it is to copy everything into a new database and start over.  Any ideas?

{Cannot open database ". It may not be a database that your application recognizes, or the file may be corrupt}
garyrobbinsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chad FranksSenior System EngineerCommented:
what version of Access?
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Could be any number of issues and need a lot more detail.

1. What version of Access?
2. Is the DB an MDB or an ACCDB?
3. Is the DB local to you or is it sitting on a server?
4. Do you get any error messages during the operation?
5. Is the app complied?
6. Is this something new or something that started only recently?
7. Do you have error trapping in-place when running the query?

Jim.
0
Chad FranksSenior System EngineerCommented:
some things to think about:

1:  Run a compact/repair on the database. (Tools ---> Database Utilities ----> Compact and repair database)
2:  There is a 2gig limit on table attachments.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

garyrobbinsAuthor Commented:
Could be any number of issues and need a lot more detail.

1. What version of Access?  - 2010
2. Is the DB an MDB or an ACCDB?  Dont know the difference the database i am querying is ODBC
3. Is the DB local to you or is it sitting on a server?  Sitting on a server
4. Do you get any error messages during the operation? At first it try's to run then in the middle i get the message, once i get the message it is instant any time I try to save a change or rerun.
5. Is the app complied?  Not sure what you mean here.
6. Is this something new or something that started only recently?  After creating I can run it once or twice a day for roughly 10 days before i get the error.
7. Do you have error trapping in-place when running the query? No, What is error trapping?
0
garyrobbinsAuthor Commented:
I am running a Compact/repair now.  I am dealing with a lot of data, so reaching the max kind of makes sense.
0
garyrobbinsAuthor Commented:
Thank you, To much data was my problem, I deleted a large amount of uneccessary data from test reports and ran the Compact/Repair and everything is working great again.

Thank you
0
mrameyCommented:
I keep getting this same error. I am no where near the 2 gig limit.

1) I have run a compact repair on the datasbase and it doesn't fix the problem.

2) The datasbase is an mdb

3) I have an archived version of Access 2010, but I originally opened the database in Access 2013. I have since been working with it only in Access 2010 but that doesn't seem to have fixed the issue

4) The problem occurs when I try to export 4 tables. All other queries and modules exported fine into the new database

5) The database was originally stored on the server, but I copied it to my desktop.

I hope that is enough information, and you might be able to point me in the right direction.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.