This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 30%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
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,
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.
Thanks Ken.
We will try your recommendation and give you feedback.
Thanks for your response.
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
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.
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
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.
Thank Ken
Appreciated
Regards
Hi Ken.
We installed a new front end, which solve the problem. All reports updating fine now.
Thanks for your advice, much appreciated
Hi George
Thanks for your response,
If I did not correctly link the non-functioning FE accedes to the back end accdb. would I not have the same problem on my second computer. Where I installed the back end accdb and the front-end accde file.
On my second computer I entered the information into the form on the front end accde file and the report updates perfectly.
The sharded folder and mapped drives were installed by the IT department.
I will ask for the mapping path.
Thanks once again for your assistance.
Is the form a bound form whose RecordSource is a table or a query whose table or tables also feed the report's RecordSource? If so does editing data in the form successfully edit the data in the table or tables in question?
Hi Ken
Thanks for your response.
Yes, the form is a bound form, who's record source is a table.
The reports record source is a query, when you open the report, it opens the enter parameter value set in the criteria for the query.The edited data in the form, successfully edits the data in the table.
The form is also linked to another report which updates the data.
It was updating fine in both reports, I was requested to add an additional report, and the problem as occurred since the IT department loaded the new updated front end accde file.
I loaded the back end and the new updated front accde file on my second computer and the reports update perfectly.
Appreciate your assistance
Thanks Alan
