Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007

    Unanswered: Weird problems with ACC2003 / ACC2007

    I have ACC2007 & ACC2003 both installed on my PC. ACC2003 is currently the default version of Access that is being utilized.

    I have seen 2 problems, which I suspect may be related to my dual installation:

    1) I have the front-end configured to "Compact on close". While I have never seen a problem with this, my users (who exclusively use ACC2003, and may not have ACC2007 installed) are seeing "left-over" files when "Compact on close" is enabled: There is a small .LDB file, and a db1.mdb file that is effectively identical to the front-end database. If "Compact on close" is disabled, the files aren't left behind.

    2) We are seeing a random "Microsoft Office Access has encountered a problem and needs to close." error when opening a secondary form of the user interface. Other users have seen this on their ACC2003 systems, but I have never seen it on mine. Unfortunately, this problem is so random, I can not reliably reproduce it to debug it.

    Another thing is that the problems appear to be occurring when the files are accessed over the network, but not with local copies (But, I haven't totally confirmed this).

    Any ideas? Or, anything I can focus my hunt on?
    Last edited by azjazz; 12-12-08 at 20:15.

    "I'm afraid the holodeck will be society's last invention." - Scott Adams

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    1. Don't compact on close. There is no good reason to need to do it to a front-end database.

    2. Can't offer much help there; there isn't much to go on.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Dec 2004
    Madison, WI
    Make sure everyone has adequate permissions to the folder on the network (ie. read/write). It sounds like a network hiccupping/slow connection issue. Especially if everything works fine on their local drive.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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