Issue opening Access Database in Access 2010 64-bit

Hey there,

Having an issue with an access database when we try to run a query on anything - it will just crash the application.

I have tried the following:

1. Re-installing the entire Office package (64-bit)
2. Installed Office SP1 update
3. Installed the KB that apparently addresses these issues.
4. Tried recompiling the database, still no luck.

The only thing I was left to try was to try with jsut the Access runtime instead and see if this solves the issue. However, this setup is working on a different computer just fine.

The computer is windows 8 64-bit. I will get some further information (logs etc) shortly to post.

Thanks,
Kelly
LVL 1
itGeniusAsked:
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.

GrahamMandenoCommented:
Hi Kelly

It sounds like your database is corrupted in some way.  Try the following procedure:

1. Take a backup copy of your database (MOST IMPORTANT!)
2. Open the database using the bypass (shift) key and perform a compact/repair, holding the shift key down as it reopens to prevent any code from running.
3. Close the database and decompile it (see here for instructions: http://datagnostics.com/dtips/decompile.html).  Once again, hold the shift key as it opens to prevent code running.
4. Repeat step 3 (decompile)
5. Repeat step 2 (compact/repair)
6. Open any code module and compile the project.

If this does not fix the problem, then the corruption may be in an object structure, not in the code, so post back here for further instructions.

Good luck!
Graham Mandeno [Access MVP 1996-2013]
0
itGeniusAuthor Commented:
Hey Graham,

Thanks for the thorough guide. I have tried the above steps, but unfortunately the problem still remains.

Would it being on Windows 8 affect this at all?

Thanks,
Kelly
0
GrahamMandenoCommented:
Hi Kelly

This is unlikely to have anything to do with Windows 8.  It sounds like more serious corruption.  Do you have a working backup copy of the database you can go back to?

If not, the next thing to try is creating a new database and importing all the objects from the old one to the new.  Be sure to TURN OFF Name Autocorrect before importing anything.  

Is there any one object (form, query, etc) that causes the crash when it is opened?  If so, then it is a good idea to leave this object out of the import and recreate it from scratch in the new database.

Best wishes,
Graham
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<However, this setup is working on a different computer just fine.>>


 Get a copy of the DB from the station where it is working, then try that on the one that's failing.

 If it still fails, then it's the environment that's at fault.

Jim.
0
GrahamMandenoCommented:
Hi Kelly

I missed the sentence about "working on a different computer" in your original post.  Have you tried using a copy from the computer where it is working?  

In my experience, corruption usually happens in the forms and code, not in the data, so it is very important, even in a single-user environment, to split the database into a back-end (tables only) and a front-end (everything else, with linked tables to the back-end).  It is then very easy to replace the front-end with a working copy and you have not lost any data.

If you google access database corruption you will find a wealth of information on preventing and recovering from corruption.  Here are a few good articles:
http://www.techrepublic.com/blog/10-things/10-ways-to-prevent-access-database-corruption/
http://allenbrowne.com/ser-25.html
http://www.everythingaccess.com/tutorials.asp?ID=Access-Database-Corruption-Repair-Guide

Also, do you have all the latest updates installed on the problem computer?  You can determine the version you are using by clicking on File > Help > Additional Version and Copyright Information.  The version looks something like this: (14.0.xxxx.yyyy).  The third number should be 6029 or later (mine is 6129).

Best wishes,
Graham
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
itGeniusAuthor Commented:
Hey there again,

Thanks for the links, a lot of reading to do! :)

So yeah I thought trying a working copy from another workstation would make it work fine, but it made no difference at all.

I thought it might be a user account problem, but a new account makes no difference either. Do we need the Access Runtime if the office version already has access with it? I can take the copy of the database to another computer and it will run just fine, which makes me think its a computer issue.

I ran the updates, and they are all up to date now, the version of Office is the same as yours Graham. I just think the issue is more on the computer seeing as the same database can be taken somewhere else and works just fine.

I did try the copy from everything to another new database, but it still crashes. Basically, it would be when I search for something in the database, would the queries crash.

Thanks,
Kelly
0
GrahamMandenoCommented:
Hi Kelly

It sounds like it is definitely an environment problem, not database corruption.

Some questions:

1. Is it only one form or query that crashes the database, or are there several?
2. Is it only on the machine(s) with the 64-bit version that it crashes?
3. Does the code have any calls to system APIs?  (Search the VBA code for "Declare")
4. check the code references (from the VBA window, go Tools > References).  Are there any ticked references apart from:
     o Visual Basic for Applications
     o Microsoft Access xx.0 Object Library
     o OLE Automation
     o Microsoft Office xx.0 Access Database Engine Object Library
If so, what are they?

Best wishes,
Graham
0
itGeniusAuthor Commented:
This was the most applicable answer. However, the actual issue resolved itself (but this helped me understand the problem and where it's coming from)
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.