Results 1 to 3 of 3
  1. #1
    Stijn is offline Novice
    Windows 11 Office 365
    Join Date
    Jan 2023
    Posts
    1

    Access is frozen after running a report with any change in design

    I have an Access-file that is being used in Production for a while.
    There are lots of tables, some VBA code, a lot of screens and also a dozen or so reports. Everything works fine, including the reports.

    Only, now I want to change something about the design of 1 of the reports. The result is that when the (changed) report is used by a user, Access freezes completely.


    This is the case for every report and for every change in the design. Even for a simple correction of a writing error, what proves it has nothing to do with a query or with the DB. When I open older version of my Access-file and I do a simple change in the design in that version, I have the same problem.
    I guess the error is introduced by an Access update ? Does anyone know the solution ?

    I'm running Office 365, version 2211, build 15831.20208

    thanks !

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Does the report query run ok?
    does the report have any calculations in text boxes? They should be in the query,not the report.

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    You should try to decompile your current file (the one that still works OK), go into the VBA editor and make sure all your modules have Option Explicit at the top then attempt to compile it; fix all\any compile error(s) that you get then finally run a Compact and Repair.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Table Design frozen
    By Synergy.ron@gmail.com in forum Access
    Replies: 1
    Last Post: 04-18-2022, 01:00 PM
  2. Replies: 14
    Last Post: 06-15-2020, 02:39 AM
  3. Replies: 6
    Last Post: 06-05-2015, 03:08 AM
  4. Replies: 13
    Last Post: 10-24-2013, 06:11 PM
  5. New design and frozen by confusion
    By grussell in forum Access
    Replies: 7
    Last Post: 09-03-2013, 12:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums