Related Topics

Corrupt Access 2007/2010 Database

Database built in 2007, edited in 2010 won't open, possibly corrupt
I have clients with both Access 2007 and 2010 in their offices, some with both in the same office. At times a database built in 2007 and then edited in 2010 can no longer be opened in the 2007 version.

Even if opened in 2010 and then compacted, it won't open in 2007. If a blank database is built in 2007, the import also won't open the "corrupted" database so the objects can be imported.

This has happened on my computer where both 2007 and 2010 are installed, and has now happened in a client office where one or the other version is installed on each computer.


Corrupt DB
My Access 2010 database is corrupt and I was wondering if anyone has suggestions of a tool that can be used to fix it.
I can open the database, but I can't open any table, form, module, etc. I also can't export, or import from another database.
Repairing with the build in Access repair tool also does not work. For all these actions the error window comes up with "Access has encountered a problem and needs to close."

Any third party tools that you know of perhaps


Corrupt DB
My Access 2010 database is corrupt and I was wondering if anyone has suggestions of a tool that can be used to fix it.
I've already checked out [LINK] as was suggested on other posts, but no success yet.
I can open the database, but I can't open any table, form, module, etc. I also can't export, or import from another database.
Repairing with the build in Access repair tool also does not work. For all these actions the error window comes up with "Access has encountered a problem and needs to close."

Any third party tools that you know of perhaps?


Can't view Access 2010 in Access 2007
Does anyone know how I can convert an Access 2010 database into a 2007 format. On the save and publish options Access 2007 is not included in the Database file types that you can save your work.

This creates problems because most people have not yet upgraded to Access 2010, nor do they care enough to do so.

I put a tremendous amount of work into building my database and now I am unable to show it to my friends so as to get some constructive feedback. I tried emailing it to them but they getthe "unrecognized database format" msg box.

Is there any way around this, or will I have to redue the entire database in Access 2007!


Will Access 2010 run an Access 2007 application?
According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes?

So why do I have the feeling that something is not going to work? Is it because I have been through too many Access upgrades


MS 2010 & 2007 major conflict
Recently I did a major no-no and installed a MS Office Prof 2010 trial without first removing 2007. Really screwed up Access database so uninstalled 2010 and 2007; then installed 2007 again, but the database (my movie database with over 750 titles) is no longer functioning properly. The database is my catalog of all those productions in my video library.

Any suggestions or ideas? Short of re-creating the database and that's not feasible


Access 2007 reading Access 2010 DB
I started working on a database with Access 2007. My office 2007 got corrupted and my IT department installed office 2010 on my computer. I continued to work on the database in 2010. When I went to use someone else computer whom has 2007 I a database engine error message that " a minimum required version to read the data is 14.0.0000.0000


Access 2007 and 2010
I brought away a client's access 2007 db and made changes to it. I only have access 2010, so I made the chages within there.

When I took the db back to the client, it came up with a message that the file either wasn't a db or it was corrupt.

Does this sound like a backward compatibility issue ? Bit severe not to open it up at all or even recognise the fact it is an .accdb when all is said and done.

I need to know if it is a compatibilty error message before I go spending time fixing the compatibility issues if really there's something completely different going on here.


Saving Access 2010 database to Access 2007
I started database in Access 2007, then I upgrade my Office to 2010. Now my upgraded database doesn't work in Access 2007. And what is worse, there is no option in 2k10 to save "in Access 2k7 mode"


database versions
I have an Access 2003 front end with Sql Server 2008 backend. Most of the users will access the database using Access 2007 and 2010. Should I upgrade the database to Access 2007 or 2010? Would it have any performance or corruption issues if I do?


Database Corrupt?
I didn't change anything on my database and my forms were working one minute, What should I do? It is looking like something is corrupt.

After I post this I am going to try to import the database into a new database to see if that works.


Access 2007 and 2010 Packaging Wizards
I have an Access 2007 (accde) file I need to package.

We would LIKE to have anyone with 2007 or 2010 to install and run it.

The Access 2007 package wizard gives 3 choices:

1. Require 2007 to be installed

2. Require 2007 runtime to be installed if Access is not already installed

3. Require nothing and install 2007 runtime.

We didn't want to mess with users configurations. They have either 2007 or 2010 already installed (full versions).

So we chose option 1. Unfortunately a user with 2010 cannot install it (even though our db will run fine under 2010)...


how to open a 2010-file in 2007 MSoffice
I have made a DB in access 2010. I want it to be opened in a machine which runs access 2007. But it says: Unrecognized database format.

I read an article here: [LINK] that attributes this problem to new features on 2010 that are not available in 2007.I can't imagine my DB without calculation or expressions in query columns.more over it will take a lot of time to remove them all one by one and substitute them with something that still fits my needs.

I think I should upgrade the target machine.


Converting features of 2007 to 2010
The team and I are just days away from delivering our database and we have hit a major issue.

We have only just been informed that the company will be using MS access 2010, however our University tutors have provided us with a laptop that runs 2007. So, some of the functional features of our database arent working correctly on the 2010 version.


Access 2010 adp bugs
I had a working adp that started life in Access 2003, was successfully upgraded to Access 2007, and has now been "upgraded" to Access 2010. A number of issues have arisen, all of which seem like Access 2010 bugs to me.

The Access 2007 version and the Access 2010 version are both connecting to the same SQL Server 2008 database. The issues only exist in Access 2010.

* A form which used Me.OrderBy to sort the recordsource crashed Access 2010 after working fine in Access 2003 and 2007.
* Settings for a form's InputParameters which worked fine in Access 2003 and 2007 now crashed Access 2010.
* Access 2010 incorrectly decided that a foreign key id field in a form "cannot be updated because it is an autonumber". In this particular case, the problem does NOT occur if the record source is "Select P.* From dbo.Payment P", which is the table containing an actorID foreign key.


VBA project is corrupt
When I'm trying to open my Access 2003 database - I receive this error: "The Visual Basic for Applications Project in the database is corrupt."


Linking the tables in old Access database 2007 to Access 2010.
I have 2010 Microsoft on my home computer. We use data files to do our homework. I noticed that the Access data files are in Microsoft 2007. What do I need to do to convert the 2007 Access to Access 2010.


2010 DB still shows 2007??? Can't compact/repair.
I have a db created in 2007, but my users have now upgraded to 2010. The db works fine mostly, but I am puzzled:

When I open the db in 2010, at the top in parentheses it says "Access 2007". Fine, I thought it was just warning me that it was still in 2007 format and maybe I should consider converting. But I can't find any way to do that. In fact, under options, where I can set the default format for a new, blank database, 2010 isn't even an option!

The reason I started looking into this is that I can't run compact/repair on this database from 2010. I get error "you need full permissions in the directory.". Buf I have confirmed that I can create and delete files in the directory, so what gives?
This article
http://answers.microsoft.com/en-us/o.4-1b99863bdde6
seems to indicate that it's a problem with running a 2007 db in 2010. So how do I convert? Or, any other guesses as to what the problem might be


Access 2007 to Outlook 2010
I have an application written in Access 2007 that automatically sends emails with attachments through Microsoft Outlook.

I have installed this onto a users system using the Access 2007 runtime. This user has Office 2010 (not Access). Access 2007 fails when trying to create emails in MS Outlook 2010.

Does anyone know of a solution to this? Apart from upgrading to Access


Conversion To Acc2007 or beyond Suggestions ?
I am currently still using Access 2000 for my database development. The Acc 2000 also works with no problem with Acc 2003. I have also made some minor changes to resolve some issues with Access 2007 and it works with Access 2007.

There is a Office 2010 coming out soon and I assume the Access 2007 will work it with very minor issues if any.

My question is when you do recommend that I convert my database from Access 2000 to Access 2007 or Access 2010 ? but I also realize that I must convert it over to Access 2003, then to Access 2007 for best results.

What do you recommend for me ?