<div>
Greetings Scotto13!<br />
<br />
&nbsp; If the query is placed in an mdb built solely to be launched and run your query <br />
<br />
&nbsp; Name a macro that launches the query &quot;autoexec&quot;<br />
&nbsp; Have the &quot;autoexec&quot; macro launch the query and then shut down the application on a good complete run<br />
&nbsp; Have Task Scheduler launch/open the mdb on your schedule<br />
<br />
regards<br />
:)-j-
</div>


Greetings Scotto13!

  If the query is placed in an mdb built solely to be launched and run your query

  Name a macro that launches the query "autoexec"
  Have the "autoexec" macro launch the query and then shut down the application on a good complete run
  Have Task Scheduler launch/open the mdb on your schedule

regards
:)-j-

<div>
Thanks shanesuebsahakarn! &nbsp;This works perfectly.<br />
<br />
Scotto13
</div>


Thanks shanesuebsahakarn!  This works perfectly.

Scotto13

<div>
<div class="content wysiwyg-content">
I have an existing database that I am using to create records. &nbsp;The user clicks on a button to add records. &nbsp;This method is dependent on the user to do this every thirty days. &nbsp;<br />
<br />
Can Access automatically run a query every thirty days? &nbsp;I want the query to autorun whether a user has been in the database or not. &nbsp; Can Access update the data in a database on its own?<br />
<br />
Scott
</div>
</div>


I have an existing database that I am using to create records.  The user clicks on a button to add records.  This method is dependent on the user to do this every thirty days.  

Can Access automatically run a query every thirty days?  I want the query to autorun whether a user has been in the database or not.   Can Access update the data in a database on its own?

Scott

Automatic Update every 30 days

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.