Split Access Database Keeps Crashing

koolwaters

Active Member
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?
 

Micron

Well-known Member
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...
 

koolwaters

Active Member
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.
 

Micron

Well-known Member
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.
 

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top