Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-17-2019, 09:39 AM   #1
Gregory Peck
Newly Registered User
 
Join Date: Jul 2019
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Gregory Peck is on a distinguished road
Open last database when access is opened

Hello. I just got some great help from this forum so I thought I would try my luck with another question.



A few years ago I set up a database and form for our products. At the time I found a setting that makes it so that access will open to the database that we are using when we open access. It worked great but then I made a new updated database and no matter what I do I can not get it to not open the first database when opening. I made yet another newer version but it still opens the the first database I made years ago when I open access and I have to go to file/open and select a the new version.



Any ideas on how to clear out the old one and put in the new one?


Thank you.

Gregory Peck is offline   Reply With Quote
Old 07-17-2019, 09:44 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,602
Thanks: 38
Thanked 875 Times in 858 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Open last database when access is opened

Hi. Interesting. How exactly did you set it up? When I open my Access program, I get a screen showing a list of all "recent" files/database I opened earlier, so I can choose from it the one I want to open or browse to a new one.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 07-17-2019, 10:01 AM   #3
Gregory Peck
Newly Registered User
 
Join Date: Jul 2019
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Gregory Peck is on a distinguished road
Re: Open last database when access is opened

If you go to File/options/client settings ans scroll down to the advanced area there is a check box to "Open last used database when access starts".


If I uncheck the box I get the list to open from. Recheck it and it opens the old sheet. Errrr

Gregory Peck is offline   Reply With Quote
Old 07-23-2019, 06:31 AM   #4
mike6271
Newly Registered User
 
Join Date: Sep 2008
Posts: 18
Thanks: 8
Thanked 0 Times in 0 Posts
mike6271 is on a distinguished road
Re: Open last database when access is opened

Double clicking the accdb file will open the file.

Surely that works?

mike6271 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
The Microsoft Jet database engine cannot open the file ''. It is already opened exclu prabhus Queries 1 12-20-2012 02:15 AM
Access database when opened on 2003 and 2010 aman General 0 02-08-2012 05:29 AM
Does Access keep a temp file of an opened database? rudeboymcc General 2 11-23-2010 02:05 AM
Can't Open asp.net page If MS Access 2003 db is Opened Directly KevinM ASP and ASP.NET 2 04-06-2006 12:36 AM
Open a form when Access is opened jguscs Modules & VBA 6 07-31-2003 09:51 AM




All times are GMT -8. The time now is 12:48 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World