CODEWITHSUNDEEP
ms-access
Spina97
Spina97

Reputation: 199

Can't compact an access MDB

I have a client with a reaaally old MDB which we didn't make and they can't contact the guy who did it and recently it started showing the error:

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

Even when I try to export all the tables it just keep showing the same error and if I try to Compact and Repair I get the error that I don't have permission to do so. I have tried with every single user on the computer. If I restore the previous version all new data will be lost and will just happen again eventually as it doesn't let me compact either and even if I try creating a new database or table in another database, it doesn't let me import the data into it. I can read all the tables but can't even copy that information. I'm at a loss of what to do and they asked me to have it for tomorrow.

I will be thankful for any tip you can give me for solving this error

Edit:

I have tried opening the file with a newer access to see if I can compact and it doesn't let me enter with any user even though the MDW is the same

Upvotes: 1

Views: 169

Answers (1)

Spina97
Spina97

Reputation: 199

I solved it! And this is how:

I noticed that the database was about 1'99GB which is almost the size limit of an access database so I just needed to Compact and Repair but it didn't let me because of permissions...

The database had another extra user which we didn't see before for any reason, that user was not even an admin, he was the real user who created the database (even though it kept telling me everywhere that the database was made by the admin and that he was the propietary...)

Since compacting gave me an error that couldn't find the database "Tempmsysaccessobjects", I just had to google it and found the solution in a spanish forum where they recommended creating a new database and importing all old data and with this user it let me do it!

Thank guys for helping!

Upvotes: 3

Related Questions