Question Locked

Access 2007 Error, NEED IMMEDIATE ASSISTANCE

0 helpful
20 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Good Morning,

I am having an issue, each and everytime I open my Access Database. The database was working prior to the conversion of the 2003 to 2007 Microsoft Office. when we converted in my office, it worked for about two months, then a message began showing up...

"Microsoft Office Access has detected that this database is in an inconsistent state, and will attempt to recover the database. During this process, a backup copy of the database will be made and all recovered objects will be placed in a new database. Access will then open a new database. The names of objects that were not successfully recovered will be logged in the 'Recovery Table'.

If someone knows what is happening to my system and how I can correct this in a way that will not let this occur again, PLEASE I"M BEGGING! I need this database for every day work....

Thanks!

20 replies

by lavoier

HI,
Sorry but I already knew that stuff and it didn't really assist me in determining the underlying issue I am having with Access. I can not open my database without getting the error message that my file is in an inconsistent state and that its creating a backup.

by Former member

N.T

by Former member

To convert an Access 2000 or Access 2002 - 2003 database (.mdb) to the Access 2007 file format (.accdb), you must first open the database in Access 2007 and then save it in the .accdb file format.

1. Click the Microsoft Office Button Button image, and then click Open.
2. In the Open dialog box, select and open the database that you want to convert.

Note If the Database Enhancement dialog box appears, the database is using a file format that is earlier than Access 2000. To continue, see one of the sections that follows: Convert an Access 97 database, Convert an Access 95 database, or Convert an Access 2.0 database.
3. Click the Microsoft Office Button Button image, point to Save As, and then, under Save the database in another format, click the file format to which you want to convert.

If any database objects are open when you use the Save Database As command, Access prompts you to close them prior to creating the copy. Click Yes to make Access close the objects, or click No to cancel the entire process. If needed, Access will also prompt you to save any changes.
4. In the Save As dialog box, type a file name in the File name box, and then click Save.

Access creates the copy of the database, and then opens the copy. Access automatically closes the original database.

Convert an Access 2.0 database

You can import tables, queries, and macros from an Access 2.0 database (.mdb) into an Office Access 2007 database (.accdb). You cannot, however, convert an Access 2.0 database to the Access 2007 file format by using Access 2007. To import forms, reports, or modules into an Access 2007 database, you first convert the database by using an earlier version of Access, then open the converted database using Access 2007, and then convert the database into an Access 2007 database. The following procedure explains these steps:

1. Open the database in Access 2000, Access 2002, or Access 2003.
2. Save the database in either the Access 2000 or Access 2002 - 2003 format.
3. Open the database in Access 2007.
4. Convert the database into an Access 2007 database.

Import an Access 2.0 database into an Access 2007 file

If you use an existing database in the Access 2.0 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb).

To import forms, reports, or modules into Office Access 2007, you must first convert the database by using an earlier version of Access, open the database in Access 2007, and then convert the database into the Access 2007 database format.
http://office.microsoft.com/en-us/access/HA102066241033.aspx
........................................

Please post back if you have any more problems or questions.

by lavoier

We had done this already when we implimented the new Microsoft Office 2007 program into our systems. We did this with out Access Training Technician. However, this person as well as several others we've contacted have no idea whats wrong with our databases. Its not an issue of the conversion, its a issue with the message that we're receiving. We can not open the database without this message coming up. We have several other databases that we converted which are not creating a problem, just this one, and its our largest.

by Former member

I will be able to pick up your issue if you give the lay out of what happened before and after.
I am going through my library trying to workout you issue from your post, but i need the Above info.

Please post back if you have any more problems or questions.

by lavoier

1. implimented 2007 office programs....converted properly from 2003
2. opened files to make sure working correctly
3. began using databases and entering information
4. database A (one in question) began to cause problems, creating own backups and opening in new database with recovered entries on seperate table
5. went through manage in Office button, selected compact & repair to correct problem
6. issue still persisting and message still popping up causing database to crash and screen to go blank with #### in all cells

I hope this will help as we are finding it difficult to work

by Former member

1). Make sure ALL users CLOSE the database, and then you open the database you want to compact and repair.

2). Click the OFFICE button, and then point to MANAGE.

3). Click Compact And Repair Database.

Have you done and gone through the above?.

by lavoier

Yes, when the database crashes, everyone using it, gets out. We move the backup which Access created into a seperate file folder on our network drive. Then one person does a compact & repair. Once its been completed, they notify the others that its been done and they can go back in and use it again. However, its still crashing and creating backups.

by Former member

What to do when your database starts acting erratically, or when even the simplest tasks cause Access to crash?. Problems of this type can occur when a database get corrupted or when the database file becomes too large. A database can become corrupted when, for example, Access suffers a system crash. Access can repair many of the problems associated with a corrupted database. The size of the database file may also be the trouble. When you delete objects such as forms and reports, Access does not reclaim the space they occupied. To use this space, you have to COMPACT the database, allowing Access to rearrange the data, filling in the space left behind by the deleted objects.

by lavoier

okay, we have one main table and then run off of queries. We do not use forms, reports or anything other than the Queries themselves. I know this is a backwards way of using Access but its the way they were using it when I took this job. Now there are issues. None of my databases are corrupt, yet the one in question is the issue. it continues to cause problems, creating backups and loosing lines and enteries previous entered that day. Thus the database could state that it is 80,000kb and then once the backup is created in the system, the database now only shows 39,000kb. Is this an error or something gone wrong with the backup?

by Former member

It sounds that it tries to do a back up but then crashes out at the last minute. have a look at the amount of memory your server has and make sure that you have enough disk space for your server to do this or get the server to do a back up on a bigger disk. Just a thought.

by Former member

If they need the backup copy of the database they can use the OPEN button to restore and view the data.

by lavoier

We have a massive server that runs all our systems. There is never a lack of space. It has nothing to do with the amount of disk space required. Our database isn't even that large compared to others I've seen.

by Former member

Put it this way, how big is Massive?.
I do not know your set up so that is why i am asking.
People i deal with do not even know what "RAM" means let alone "hard drive". A bit off topic there, but it gives you an insight on why i asked in the first place.

So going on your Massive server on which you have a big problem with your database.
You have given me a task to sort out, but in the mean time, i am going to give you a few links to some software in the hope it/they will get your database going. I think you will be interested with the number two link.

http://www.freedownloadscenter.com/Best/free-mdb-repair.html
http://www.everythingaccess.com/accessdatabaserepair.htm
http://www.accessfilerecovery.com/

Please post back if you have any more problems or questions.

by Former member

The compact and repair database option has moved in Access 2007. To run this feature click the Office button (upper left corner of the screen) select Manage from the list then select Compact and Repair Database and browse to the database.

Please post back if you have any more problems or questions.

by lavoier

Its been found and used several times today. Thanks!

I work for the University of Manitoba, in the CancerCare Manitoba Building. We have two rather large servers which hold the information for all of our computers. We have about 200 computers, laptops, and other wireless systems that run off of it. Not exactly sure how massive it is, but its pretty large!

by matthew.weeks

First off, try a compact and repair: Microsoft Office Button > Manage > Manage this database > Compact and Repair Database.

by boxfiddler Hot topic

he's figured it out by now. OP date is 2008.

This discussion is closed to new replies.