locked
Can Access 64 bit handle more complex Forms and queries? (error 3048 cannot open more databases) RRS feed

  • Question

  • Hi

    I have developed all my Apps in Access 32 bit. The more complex Apps some time run into error 3048 "Cannot open more databases"

    If I move my Apps from 32 bit to 64 bit Access, will it solve this issue?


    Cheers // Peter Forss Stockholm

    Monday, May 25, 2020 8:15 AM

Answers

  • From my understanding the database limit does not change, so no. 

    Where 64-bit can help is with the resource exceeded error because it gives Access more memory to work with so it can juggle larger queries, ...


    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Monday, May 25, 2020 10:15 AM

All replies

  • From my understanding the database limit does not change, so no. 

    Where 64-bit can help is with the resource exceeded error because it gives Access more memory to work with so it can juggle larger queries, ...


    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Monday, May 25, 2020 10:15 AM
  • Thanks Daniel

    Cheers // Peter Forss Stockholm

    Monday, May 25, 2020 7:37 PM
  • As already stated, the answer is no.

    The usual reason for that error is that you have too many connections in use e.g. many forms, reports, tables, recordsets etc open at the same time. Try closing all objects after use

    It is highly unlikely you will notice any benefit in moving to 64-bit, and that includes working with complex queries requiring a lot of memory.

    Monday, May 25, 2020 8:23 PM
  • The more complex Apps some time run into error 3048 "Cannot open more databases"

    Hi Peter,

    Simplification of the form(s) is not an option?

    For example, I never use list- or selection-boxes. It saves quite a lot of handles, and a lot of startup time. With the same click that the listbox is opened/expanded, a new form is opened with far, far more possibilites to make a proper choice, for the bare reason that you have more information (fields) available. Clicking the right record does all the rest. I agree, it is more programming.

    Or dynamical subforms?

    Imb.

    Monday, May 25, 2020 8:32 PM
  • Your problem is not bit related...usually is bad design leaving objects open, having dead problematic code that is "invisible" to normal C&R ...

    Just decompile the problematic applications and probably you will find it when you recompile the code

    There is some chance that your design might look good but something in it is causing corruption...i have seen and just by recreating from scratch resolved it nicely.


    Monday, June 1, 2020 11:16 AM