Users Allowed to Run Action Queries

[Guest]

I have a database that has several append queries to update historical data
collection from an ODBC server. I have code that runs the append queries on
startup of the database. However, when a user (not the admin) opens the
database, the code will not run the append queries. Any way around this? I
can't find where to give users open/run authority for queries.

 

[Joan Wild]

I assume that you have implemented Access user level security?

If so, then Tools, Security, Permissions; choose Queries in the Object list,
select the append query and grant the users permission to insert data. If
you have used RWOP queries, that's all they need. If you haven't used RWOP
queries, then you'll also need to give the users insert data permissions on
the underlying table.