Edit recent files of Access

[Notedop]

Hi,

Is it possible to edit the recent files of a access database?

We have a main database (version control database) from where you can open a database which is located on a network drive.
By selecting the datbase you need from a dropdown menu, access will check which version you have locally. If there is an updated version available on the network it will download this updated version, overwriting the old one. The 'main' database is then closed and the local version of the database you needed is opened.

The problem is that this local database is mentioned in the recent files history so people are able to bypass using the main database.

In Excel you can clear the recent files with application.RecentFiles setting the maximum to 0 and back to original again. In Access you do not have this option.

Any idea where I would be able to find this option. Ideally I'd like to only take out a specific databasename from the recent files, rather then resetting the full list.

 

[nathansav]

Can you not have the main database as just what is needed for the opening, then rather than opening you link the tables and import everything else from the selected database, this will negate the versioning issue also as as soon as the form is changed in the network version the next use will import the changes. You can prefix everything in the main db, say "$_" then you can delete everything that isnt "$_" prefixed. You will need to have the network version of the databases split though if you wanted the data updated, are the tables static in the downloaded version?

This way you are never opening the database.

 

[Notedop]

Thanks for your response!
This might be a solution however would require rebuild of our logic.
So i'd rather explore if there is a possiblity to edit the recent files of Access.

Any further input is appreciated!