Where in windows/access is the recently opened Dbs kept?

bknight
BronzeLounger
Posts: 1391
Joined: 08 Jul 2016, 18:53

Where in windows/access is the recently opened Dbs kept?

Post by bknight »

Where in windows/access is the recently opened Dbs kept?

User avatar
HansV
Administrator
Posts: 78518
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Where in windows/access is the recently opened Dbs kept?

Post by HansV »

It's kept in the registry. Where exactly depends on your version of Access.
If you have Access 2016 or later, it can be in

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\File MRU

or in

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\User MRU\<LiveId>\File MRU

where <LiveID> is a very long string identifying your Microsoft account.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1391
Joined: 08 Jul 2016, 18:53

Re: Where in windows/access is the recently opened Dbs kept?

Post by bknight »

Well I have 2007 which is 12.0. I get to 12.0/access/ and then to access connectivity or security or settings. Opening up all of them I only find information in settings. There is an other tree called Open Find with MSO Access/settings/file open and that has a hex string about 15 characters long.

User avatar
HansV
Administrator
Posts: 78518
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Where in windows/access is the recently opened Dbs kept?

Post by HansV »

How about

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\File MRU
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1391
Joined: 08 Jul 2016, 18:53

Re: Where in windows/access is the recently opened Dbs kept?

Post by bknight »

No such tree entry.

bknight
BronzeLounger
Posts: 1391
Joined: 08 Jul 2016, 18:53

Re: Where in windows/access is the recently opened Dbs kept?

Post by bknight »

Here is a screen shot of the registry.
The first is stating at12.0 the second is below the top image.
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78518
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Where in windows/access is the recently opened Dbs kept?

Post by HansV »

My apologies that I couldn't help you. I hope that someone else who still has Office 2007 knows.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1391
Joined: 08 Jul 2016, 18:53

Re: Where in windows/access is the recently opened Dbs kept?

Post by bknight »

No problem.

bknight
BronzeLounger
Posts: 1391
Joined: 08 Jul 2016, 18:53

Re: Where in windows/access is the recently opened Dbs kept?

Post by bknight »

I looked at Excel and there is HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\File MRU
Just not with Access.

User avatar
Gasman
2StarLounger
Posts: 104
Joined: 22 Feb 2022, 09:04

Re: Where in windows/access is the recently opened Dbs kept?

Post by Gasman »

Mine is at

Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\12.0\Access\Settings

FWIW, all I did was search for the first file on the list.
You do not have the required permissions to view the files attached to this post.
Using Access 2007/2019.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.

bknight
BronzeLounger
Posts: 1391
Joined: 08 Jul 2016, 18:53

Re: Where in windows/access is the recently opened Dbs kept?

Post by bknight »

Yes that is where mine are at. If you look at the images I just clicked on settings tree without selecting settings. Worked great along with your suggestion of searching the name.
Thanks