Can't edit queries

Brass Contributor

I’m trying to edit queries in an access database. I’ve copied it to my harddrive but when I open it I get the message below.

u156531_0-1698698876635.png

 

 

If I click the OK button I get this message.

 

u156531_1-1698698876638.png

 

If I click Enable Content I can’t edit any of the queries. I need someone to show mw how to enable the editing of the queries.

 

2 Replies

Hi,

 

Depending on where/how you got the file from and what your workplace and permissions look like, there are several methods to get rid of the warning/blocking. see e.g. this thread

 

Servus
Karl
****************

Access Forever

Access News
Access DevCon

Access-Entwickler-Konferenz AEK

@u156531 

The problem appears to be, at least in part, that you have not designated the folder where the accdb is stored as a Trusted Location. You can do that under Options here: 

GeorgeHepworth_0-1698749537616.png

 

There is also a possibility that the accdb has been designated as read-only when you copied it from some location to your hard drive. Read about that here.