Search results

  1. J

    Question Corrupt access front end accdb after mixing office versions

    I have a problem with a DB I started work on a couple of years ago in Access 2010. I fired it up last week and now I'm getting an "unrecognized database format" error when I try and open the front end. I left this project sat after the company lost interest in finishing it. Since then I worked...
  2. J

    Back to work on an old project and greeted with "unrecognized database format"

    Back to work on an old project and greeted with "unrecognized database format" Today I fired up a front end which I started developing almost two years ago, as we now have a need to finish the project. I wasn't expecting it to be all plain sailing as since I last worked on it, my development...
  3. J

    Please help with nested aggregate query

    I have the following query, which is producing the results I need in my overview report, but it is EXTREMELY slow! It takes almost 12 seconds to execute on the local machine with is a very high spec brand new quad core machine with 8GB of RAM. This database will be running across a network, with...
  4. J

    Complex SQL query help pls

    I have a database where I have have (correctly I think) normalised out my data, however now Im trying to create some queries which pull data from four different related tables and Im really struggling. My database is built around a Plots table (tblPlots) which has the following fields PlotID -...
Back
Top Bottom