VB Project cannot open access db until MS Access program is started

[manx44]

I have been working with access databases in VB projects for all my career, always with 2003 mdb format. Last week, I bought Access 2024, and saved a well-used database as an accdb. My VB project started up fine for a few days, then suddenly refused to open. No error message - just waits for about 30 seconds then gives up. No error occurs. I noticed, by accident, that if I start Access 2024 while my project is waiting, it suddenly continues, and all seems well.

The database is password protected, and this is supplied in the connection string as usual.

I thought I might not be closing the database properly, but the code executes the .Close correctly. I see there is a Trust Center in Access 2024, but have left it alone until I know more about it.

Any ideas ?

 

[LarryE]

Your ACCESS files always need to be in a Trusted Location, so open Trusted Locations and make sure your file location is there. If not, add it.

 

[manx44]

This database is downloaded from a website and installed along with the software on a client's PC. They will not have MS Access installed, so how do they set a trusted location ? I never had this trouble until I installed MS Access 2024 on my PC.

 

[Gasman]

Most people have to tick/untick a a checkbox to get anything to run, after downloading a file from the internet.
They would need Access runtime to run the DB.
As for trusted locations

trusted locations VBA - Google Search