Access: Report not updating from a form. Form linked to other reports that all update.

Question

Access: Report not updating from a form. Form linked to other reports that all update.

Alan Fealey 20

Good day, Ladies and Gents.

I have a split access database, which has been loaded onto Access Runtime.

I have one report which is not updating the information entered into the form.

The form is linked to other reports which all update.

I have tested the split database on my second computer and the report updates fine.

Could this be an issue with the instillation on the front-end. All other reports, queries and forms are working perfectly.

Your advice will be greatly appreciated.

Many Thanks

Alan,

Accepted answer

7 additional answers

Your answer

Answer 1

Ken Sheridan 3,106

It may be that the report in the first machine's front end file has become corrupted. Try copying it to the clipboard and then pasting it back under a new name. Open the new copy and see if that correctly returns the data from the table. If it does then delete the original report and rename the copy back to the original name.

Alan Fealey 20 Reputation points

2025-07-31T03:44:27.5766667+00:00

Thanks Ken.

We will try your recommendation and give you feedback.

Thanks for your response.
Alan Fealey 20 Reputation points

2025-07-31T11:21:12.2766667+00:00

Hi Ken

The IT person his not at work today, the machines that are not updating are at site.

The front end accde file was loaded onto three computers with access runtime.

The report is not updating on any of the three computers.

Do you think all three-front end accde file could be corrupted?

I have the main accdb file on my first computer and the report runs fine. I also install a back end and a front end accde file on my second computer and the reports runs fine.

Both my computers are off site.

Regards

Alan
Ken Sheridan 3,106 Reputation points

2025-07-31T20:33:35.5566667+00:00

If copies of the same .accde file were installed on the three machines, then the corruption could have been in the file already before the copies were made.
Alan Fealey 20 Reputation points

2025-08-01T03:43:52.4+00:00

Thanks Ken,Would you recommend your first recommendation Try copying it to the clipboard and then pasting it back under a new name. Open the new copy and see if that correctly returns the data from the table. If it does, then delete the original report and rename the copy back to the original name.

Or

Compact and Repair the master accdb file and convert to a new accde file and reinstall on the three computers on site.

Thanks, and appreciate your advice and support
Ken Sheridan 3,106 Reputation points

2025-08-01T12:49:27.11+00:00

Yes, I'd recommend that. If an object is corrupted I've found that this will more often than not cure it. If not, you still have the original object, and can look for other reasons for the errant behaviour. Recreating the accde file could be the next step. Another option, of course would be to go back to the most recent back-up of the front end which does not exhibit the behaviour.
Alan Fealey 20 Reputation points

2025-08-01T13:22:23.0633333+00:00

Thank Ken

Appreciated

Regards
Alan Fealey 20 Reputation points

2025-08-15T08:04:38.93+00:00

Hi Ken.

We installed a new front end, which solve the problem. All reports updating fine now.

Thanks for your advice, much appreciated

Answer 2

Hi @Alan Fealey

Based on your description, we understand that you're encountering an issue with the access report where data cannot be updated on your device, although it works correctly on another device. We are glad to assist you this part.

To troubleshoot it effectively, could you provide additional information due to the following question:

Have you checked whether the Access Runtime versions match on both devices?Ensure the Access Runtime version on the primary computer matches the one on the second computer. Mismatched versions can cause inconsistencies, especially with report rendering
Are there any error messages when you run the report on the primary computer, or does the form simply fail to display any data?

If it possible could you try to:

Replace the Front-End File from second device to the primary one ( This can help you to avoid issues caused by a corrupted front-end).
Reinstall Access Runtime ( Ensure this match with the second computer version).

If you need further assistance, please let us know.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Alan Fealey 20 Reputation points

2025-07-29T18:02:54.8833333+00:00

.Hi Hin-V

Thank you for your reply.

The Access Runtime versions are not on my computers.

I was asked to design a database.

I design the database on my first computer,

I then split the database with encrypted front end.

I email the back-end .accdb file and front end accde file as ZIP files.

Access Runtime was then loaded on each computer.

The back end was set up on the server. Each individual computer as a separate front-end accde file.

The issue with the report not updating is on the individual computers, I tested on two separate computers, and both did not update the report.

The one report which is not updating, the information entered into the form.

The form is linked to other reports, which all update.

I then email the back end .accdb file and front end accde file as ZIP files to my second computer, I then tested on my second computer.

I then entered information into the form and the report updates perfectly.

Hope this helps.

Thank you.

Answer 3

Hi Hin-V

Thank you for your reply.

The Access Runtime versions are not on my computers.

I was asked to design a database.

I design the database on my first computer,

I then split the database with encrypted front end.

I email the back-end .accdb file and front end accde file as ZIP files.

Access Runtime was then loaded on each computer.

The back end was set up on the server. Each individual computer as a separate front-end accde file.

The issue with the report not updating is on the individual computers, I tested on two separate computers, and both did not update the report.

The one report which is not updating, the information entered into the form.

The form is linked to other reports, which all update.

I then email the back end .accdb file and front end accde file as ZIP files to my second computer, I then tested on my second computer.

I then entered information into the form and the report updates perfectly.

Hope this helps.

Thank you.

Answer 4

It sounds like you did not correctly link the non-functioning FE accdes to the back-end accdb. That will need to be done prior to converting the FE accdb to an accde.

It's highly unlikely to be the case that different "versions" of an Access FE accde itself are the problem unless it is due to the potential linking problem.

Do you use mapped drives in your organization for the shared folder where the BE accdb resides? If so, it's necessary to ensure that the linked tables use the same drive mapping. Even better is to use UNC naming, not mapped drives for the link to the BE accdb on the shared drive.

Answer 5

George Hepworth 21,900 Volunteer Moderator

One additional consideration is whether you designated the folders on the users' computers as Trusted Locations.

Share via

Access: Report not updating from a form. Form linked to other reports that all update.

7 additional answers

Your answer