"Shell" de bug

[JimO]

I am trying to open another Access data base from another using the following formula.

Shell "ACCESS.EXE C:\Users\Jim\Desktop\TRUSTED\AASport.accdb", vbNormalFocus

I get a Run-time error '53' message.

Thoughts?

Jim O

[ranman256]

shell is a function ,
and you may need the full path to Access:

call Shell ("c:\program files\ACCESS.EXE C:\Users\Jim\Desktop\TRUSTED\AASport.accdb", vbNormalFocus)

[isladogs]

Just to confirm you do need the full path to the Access program file which is called MSAccess.exe
The code will then work with or without using Call.
If Call is used you need the brackets, otherwise not.

Here is another method of doing the same thing

Dim db As DAO.Database
    
Set db = DBEngine.OpenDatabase("full path to your database.accdb")