Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to Access Forum    Comments List
Upload Images | @Reply | Bookmark | Link | Email | Next Unseen |
Access Database Launcher
David Forney 
    
40 days ago
I have several databases and none are related in any way. To navigate to a specific database file (accdb) I must open my Access program where a listing of all my database files are located. If I select one, it then opens. My question is: can a new access database file be created with a menu form to access the database files and open them as they do in the Access program? I would rather not have users have unrestricted access to my databases that you have in the Access program listing.
Alkan Toykan  @Reply  
       
40 days ago
Yes. You can do this quite easily by creating a separate Access database that acts as a small launcher for the databases you want your users to access. For example, you could create a form containing:
- A checkbox for each Access database
- The name of the database next to the checkbox
- An Open button

When the user checks a database and clicks Open, VBA can open the selected accdb file using either FollowHyperlink or Shell. For example, with a checkbox named chkStok

Private Sub btnOpen_Click()
    If Me.chkStok = True Then
        Application.FollowHyperlink "C:\AccessDB\Stok.accdb"
        ' Shell "msaccess.exe ""C:\AccessDB\Stok.accdb""", vbNormalFocus
    End If
End Sub


The If statement simply asks "Is the Stok checkbox checked?". if the answer is Yes -meaning True- Access executes the following line for either Application.FollowHyperlink ..... or Shell "msaccess.exe ..... , whichever you wanna use or understand the best. (The difference is that FollowHyperlink lets Windows handle the file, while Shell explicitly starts Microsoft Access and passes the database file to it.) If the checkbox is not checked, Access does nothing.
This way, the launcher database becomes the user's starting point, and you can decide which databases are presented to them instead of relying on Access's own list of recently opened databases.
Kevin Robertson  @Reply  
          
40 days ago
A Glenn Yesner  @Reply  
     
40 days ago
If there are ten different databases but some users get access only to certain ones you can set up a permissions table so the launcher, on the landing page, only shows the particular databases that are available for that particular user.
Richard Rost  @Reply  
           
40 days ago
Yep, Kevin's got it. I have a Database Launcher video specifically for this purpose. It basically uses the method that Alkan suggested.

One important note: the launcher can limit what users see and make navigation easier, but it isn't security by itself. If users can browse to the ACCDB files and have permission to open them, they can still do so. For real protection, secure the folder with Windows permissions and consider distributing the front ends as ACCDE files.
Sam Domino  @Reply  
       
40 days ago

Sam Domino  @Reply  
       
40 days ago
Here is the Database Launcher I built several years ago.  The right side shows a random collection of "messages".  LLAP!!!
Richard Rost  @Reply  
           
40 days ago
Love the LCARS look!
David Forney OP  @Reply  
    
40 days ago
Gentlemen
This is exactly what I was looking for. Security is not an issue as all my databases are exclusively for my own personal use. I just don’t want one of my grand or great grandchildren to accidentally delete one of my databases. Had I known what you call it (database launcher) perhaps I could have found it without bothering you all.
Again thank you for the help and rapid response.
David Forney OP  @Reply  
    
39 days ago

David Forney OP  @Reply  
    
39 days ago
Unfortunately, I have a glitch in my Database Launcher.
David Forney OP  @Reply  
    
39 days ago

David Forney OP  @Reply  
    
39 days ago
When I click the “Open Ship List” button the following warning comes up.
David Forney OP  @Reply  
    
39 days ago
If I click yes to continue
My Ship List menu opens as it should.
David Forney OP  @Reply  
    
39 days ago
The files are in a trusted folder
Any ideas?
Kevin Robertson  @Reply  
          
39 days ago
Are subfolders also trusted?
David Forney OP  @Reply  
    
39 days ago
yes
Kevin Robertson  @Reply  
          
39 days ago
Are you using FollowHyperlink?
Try using Shell instead.
David Forney OP  @Reply  
    
39 days ago

David Forney OP  @Reply  
    
39 days ago
What is shell and how do you do it?
David Forney OP  @Reply  
    
39 days ago

David Forney OP  @Reply  
    
39 days ago
yes sub folders are trusted as well
David Forney OP  @Reply  
    
39 days ago
yes using FollowHyperlink
David Forney OP  @Reply  
    
39 days ago
I can screen shot the vba code if needed
Donald Blackwell  @Reply  
       
39 days ago
Richard shows how to get around this with the shell command in Security Warning
David Forney OP  @Reply  
    
39 days ago
I will go look at it
David Forney OP  @Reply  
    
39 days ago
am I getting this because I am using an external hard drive? If so I could move my files to my laptop's C drive
Kevin Robertson  @Reply  
          
39 days ago
Assuming the full path to the database is in the third column.
[ID, DatabaseName, FullPath]

Shell "explorer.exe """ & LauncherList.Column(2) & """", vbNormalFocus

Rename LauncherList to whatever the name of your list box is.
Richard Rost  @Reply  
           
38 days ago
No, the external hard drive isn't the issue. That's a warning Access can display when FollowHyperlink opens another Access file, even when the files are in a trusted location.

Kevin's suggestion to launch it with Shell instead is the right fix. The Security Warning video Donald linked to shows how to replace the FollowHyperlink line.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
 
What's This?

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 11/17/2026 2:13:21 AM. PLT: 0s