Access error after upgrading from Windows XP to Windows 7

Anything and everything software related that doesn't fit above can go in here!
Post Reply
EeroHukkanen
Legit Little One
Legit Little One
Posts: 4
Joined: Wed May 11, 2016 5:34 am

Access error after upgrading from Windows XP to Windows 7

Post by EeroHukkanen »

I have a client that recently upgraded from Windows XP to Windows 7 64 bit workstations. They are running Office 2007 Pro with SP3.
After the upgrade their access database program started failing and giving the following error message:
"Microsoft Office Access has detected that this database is in an inconsistent state, and will attempt to recover the database.
I am not sure why this is happening. Any ideas?
EeroHukkanen
Legit Little One
Legit Little One
Posts: 4
Joined: Wed May 11, 2016 5:34 am

Re: Access error after upgrading from Windows XP to Windows 7

Post by EeroHukkanen »

Here is the full error message: Microsoft Office has detected that this database is in inconsistent state and this database 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 the new database. The names of the objects that were not successfully recovered will be logged in the ?Recovery Errors? table.
The database itself is on a network share (windows server 2012). It was working fine when we were running XP on the desktops. Nothing changed except for the workstations
EeroHukkanen
Legit Little One
Legit Little One
Posts: 4
Joined: Wed May 11, 2016 5:34 am

Re: Access error after upgrading from Windows XP to Windows 7

Post by EeroHukkanen »

already tried this:
Putting a database on a server is asking for trouble if it also has the forms,
queries, reports, modules and macros. These objects corrupt easily over a slow
network or when multiple users are in the database.

Best practice is to split the database using the Database splitter under the
database utilities on the menu. Be sure to do it on your local copy. Once the
database is split move the back end (the file with just the tables) to the
server and give each user a copy of the front end. best of all, if a user does
manage to corrupt his copy of the FE you just have to give him a new one and the
data remains safe.
Bielecki
Legit Little One
Legit Little One
Posts: 2
Joined: Fri May 20, 2016 6:34 am

Re: Access error after upgrading from Windows XP to Windows 7

Post by Bielecki »

So you have split the database, and you now have the Data portion (i.e. the "Backend") on the server, and the UI portion (i.e. the "Frontend") installed directly on each user's workstation? They're not running the Frontend from a network share?
The error you're getting generally means corruption, so have you performed maintenance on the database?
If not, then first make a backup and then do these things:
1. Compact the database
2. Compile the database - from the VBA Editor click Debug-Compile. Fix any errors that are found, and then continue doing this until that menu item is disabled.
3. Compact the database
You may also need to Decompile it. To do that, create a shortcut with this as the Target:
"full path to msaccess.exe" "full path to your database" /decompile
Run this shortcut, then do the 3 steps above
You might also consider moving everything over to a new, blank database. This takes care of any container corruption.
Perhaps this topic is on the Microsoft something to help. https://social.msdn.microsoft.com/Forum ... outlookdev
Bielecki
Legit Little One
Legit Little One
Posts: 2
Joined: Fri May 20, 2016 6:34 am

Re: Access error after upgrading from Windows XP to Windows 7

Post by Bielecki »

Otherwise, if everything is corrupted then you may help the utility Access Recovery Toolbox. This way, you will save if not all the information, then at least some part. http://www.oemailrecovery.com/access_recovery.html
Be sure that ALL machines are fully up to date regarding Office and Windows. Check the Windows Update history to be sure that you don't have bunch of failed updates.
EeroHukkanen
Legit Little One
Legit Little One
Posts: 4
Joined: Wed May 11, 2016 5:34 am

Re: Access error after upgrading from Windows XP to Windows 7

Post by EeroHukkanen »

You've been very kind in your efforts to help. Thanks for that. Solved!
Post Reply