[AccessD] How to Open an Access accdr file from an Access accdb file

Brad Marks bradm at blackforestltd.com
Fri Nov 18 16:18:01 CST 2016


All,

I have an Access application (accdb) that currently opens a second accdb with code like this. 

Set MyAccess = CreateObject("Access.Application")
MyAccess.Visible = True
MyAccess.OpenCurrentDatabase ("K:\Test.accdb")

I would like to use an accdr file instead of the accdb file 

"K:\Test.accdr" instead of "K:\Test.accdb" 

I thought that this would be a simple change.  However, when I try this, I receive a message that Access can't open the database.

Is there a way to do this?

Thanks,
Brad



More information about the AccessD mailing list