Results 1 to 4 of 4

Thread: Split Access Database Keeps Crashing
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2007
    Location
    Bahamas
    Posts
    403
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Split Access Database Keeps Crashing

    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?
    Love Life!!!!

  2. #2
    Board Regular
    Join Date
    Jun 2015
    Location
    Ontario, Canada
    Posts
    1,719
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Split Access Database Keeps Crashing

    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...
    Tips for posting problems:
    1) "doesn't work" doesn't help. Post error message text/numbers and/or state what's happening.
    2) if posting code or sql, use code tags; specify on which code line errors occur, if applicable
    3) try to be specific; assume we know nothing about your issue - because we don't!

    Make all suggested changes in copies of your database or to its objects.

    "1 out of 1010 people understand binary. The other 1001 don't."

  3. #3
    Board Regular
    Join Date
    May 2007
    Location
    Bahamas
    Posts
    403
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Split Access Database Keeps Crashing

    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.
    Love Life!!!!

  4. #4
    Board Regular
    Join Date
    Jun 2015
    Location
    Ontario, Canada
    Posts
    1,719
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Split Access Database Keeps Crashing

    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

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •