Edit content takes forever (1 Viewer)

[Joy83]

Hello,
I have two files
One runs the code (interface)
Otherone is for the database

every time I enhance the interface I add the file in a share folder where everyone can get in save in their local machine

I updated the interface this time
I uploaded the file in the network
When they open it they get “edit content” security warning which usually should take 30 sec
But now I get it forever with no luck to open the file.

i tried to investigate but didn’t know the issue
Note that I don’t have this issue in my machine. Only from the users machines

What could be the problem?

 

[CJ_London]

sounds like the users are not putting the interface file (FE-Front End) in a trusted location

 

[Joy83]

sounds like the users are not putting the interface file (FE-Front End) in a trusted location

sounds like the users are not putting the interface file (FE-Front End) in a trusted location

Hi

Thanks for your reply
The trusted network is added
It used to work nothing changed in the setting

what else could be the problem

 

[CJ_London]

depends on your access version but the the last couple of windows updates has caused some problems - check your version against your users versions, you may need to roll back the updates - see links at the bottom of this thread for the problem and the fixes

 

[Joy83]

I downloaded Microsoft access database engin 2016 redistributable for 32 and 64 applications

Could this be the issue?

 

[CJ_London]

I believe 2016 suffers from the update bugs.

 

[Joy83]

Insee
Is there any way to all the content from the code

 

[CJ_London]

don't understand

 

[Joy83]

The issue os caused when users press on “edit content”
The access hangs and crashes

is there any way to avoid this msg by writing a vba code or something
I tried the setting but didn’t work

 

[CJ_London]

think you need to provide a lot more information. What is the 'edit content' button? what is the actual message? provide some screenshots?

Also are you using an autoexec macro and/or specified a form to open initially?

If so, provide the autoexec macro code and any code behind the form open, load, resize and current events

 

[Joy83]

I spasify the first form to open initially
There is nothing in the load
I just have few subforms that load automatically but loading the main form

 

[CJ_London]

per my first response, that means the app is not in a trusted location

you said 'The trusted network is added' which implies the BE file. It needs to be the location of the FE file on each users machine

 

[GPGeorge]

I spasify the first form to open initially
There is nothing in the load
I just have few subforms that load automatically but loading the main form

You might want to read this article and this one.

If this is your problem, the fix is now available, so now would be a good time to get the most recent updates for Office.

It's also true that you would want/need to put both the Front End (interface accdb) and the Back End (tables accdb) in Trusted Locations.

 

[Joy83]

The update fixed the issue
Thanks a lot