VBA Open .Accde database from Excel

[decadence]

Hi, Is it possible to open an access database from Excel that has the file extension .accde

 

[Joe4]

What have you tried?
Does this method work? https://software-solutions-online.com/vba-open-access-database-from-excel/

 

[decadence]

Hi Joe4, Yes I have tried these but I get Runtime error 429 ActiveX component can't create object, I think it is because I don't have full access, only runtime access

 

[Joe4]

See if this works: https://stackoverflow.com/questions/42351768/how-to-open-ms-access-in-runtime-using-excel-vba

 

[decadence]

Thanks joe4, This will open the Access Runtime .accde database, How would I get it to open in Maximized Focus?

CreateObject("WScript.Shell").Run ("""C:\Database.accde""")

 

[Joe4]

How would I get it to open in Maximized Focus?

I do not know. I found this (don't know if you can incorporate this into your code, but worth a try):
https://www.pcreview.co.uk/threads/vba-to-maximize-the-application-window.2924800/

 

[decadence]

Figured it out... Thanks again joe4

CreateObject("WScript.Shell").Run ("""C:\Database.accde""", vbMaximizedFocus)