Link to home
Start Free TrialLog in
Avatar of João serras-pereira
João serras-pereiraFlag for Portugal

asked on

cannot modify a split back end in ms/access 2013

I had a on file database ad then made the split. Now I need to modify some tables and ms/access 2013 does not allow to modify them either via the front end or, directly, in the back end (on the back end refuses to open the file due to "a security concern" and requires me to digitally sign the file, which I do not know how to do.
I went to the trust center and added the back end location as a trusted locations, but it did not help.

what shall I do? can anyone help?
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

You cannot modify a table linked in the FE.  You must do so directly in the BE.

Close the FE entirely (make sure EVERYONE is out of the database), then copy that BE file over to your machine. Make your changes there, then copy the updated BE back to the original location.
Avatar of João serras-pereira

ASKER

Hi Scott.

thanks for the prompt answer.

I did it. Closed everything and even REBOOTED my PC to make sure that I had no tasks using the database. at no avail...

always getting the same message when I try to open the back end...

User generated image
ASKER CERTIFIED SOLUTION
Avatar of DoveTails
DoveTails
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
really thanks!!! It worked! bloody microsoft!