Split Access Database Keeps Crashing

koolwaters

Active Member
Joined
May 16, 2007
Messages
403
We recently upgraded all our systems to Windows 10 64 bit and Microsoft Office Professional 64 bit.

We were using a split access database with Office 2013 which was working perfectly. Since the upgrade, when using the database on one of the systems, it constantly crashes and then Access restarts. I imported all of the objects into a new database and the database worked fine for approximately 10 days and now it keeps crashing again.

Any suggestions as to why this is occurring and any possible fixes to this problem?
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Is there any code that hasn't been converted to handle 64 bit memory addresses? Usually this involves API calls and not regular code - except that I have read that some common library references don't work in 64. The general consensus at this time seems to be that 64 bit windows is fine, but one should install 32 bit Office. In fact, I believe it is the default choice. There must be a reason for that; one that M$ isn't offering freely...
 
Upvote 0
The code does not appear to be the issue as the database worked as intended for 10 days and then it started to crash again. I had done tests when the crashes first started to occur and once I created the new database and imported the objects, I did quite a bit of testing using the particular machine and it worked. The user then continued her usual tasks and it worked fine until yesterday. And this is the only machine out of quite a few with Windows 10 64 bit and Office 64 bit installed that is having the issue with the database.
 
Upvote 0
Afraid I have nothing else to offer then, save for suggesting you research Access and 64 bit. Lot's of info/opinion, such as 64b Windows is where the speed gain comes from, not 64b Office, and the advice is to install 32b Office on 64b Windows. Check it out and bring that to IT. That's what I have and I experience no crashing.
 
Upvote 0

Forum statistics

Threads
1,223,952
Messages
6,175,594
Members
452,655
Latest member
goranzoric

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top