Home Forums Microsoft Access Microsoft Access Access front end with SQL Express backend -- backup options? RE: Access front end with SQL Express backend -- backup options?

  • Wayne West (2/27/2015)


    ... Depending on the number of users on the system and how much back end processing is going on, you might need to be concerned about the 1 gig memory limit in Express.

    Note that the current versions of Express (2008, 2012 and 2014) will support databases up to 10 Gbytes in side (the data file - the log file isn't limited), but will only use up to 1 Gbyte of RAM, and the lesser of 1 socket or 4 cores, so you do get limited multi-thread processing. If your database is substantially larger than 1 Gbyte you may see some performance loss as data (and indexes) cannot be cached in RAM. Bottom line is we have a number of customers using Express, and are quite pleased with it.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!