Open Form in Other Database (A2K)

Topic

New Reply

Here’s what I’m attempting:

From: SRT Systems.mdb

I want to open form: frm 01 CN_99_Archives which is sitting in: SRT_ArchSys.mdb

Having trolled thru the Forum I found the following code provided by Hans back in
Post: 566,889 which appeared to answer my problem:

Dim app As New Access.Application
app.OpenCurrentDatabase “SRT_ArchSys.mdb”
app.DoCmd.OpenForm “frm 01 CN_99_Archives”
app.DoCmd.Maximize
app.RunCommand acCmdAppMaximize
app.Visible = True
Set app = Nothing

My problem is that I’m getting:

Run-time error ‘7866’
Microsoft Office Access can’t open the database because it is missing, or opened exclusively by another user.

Both MDB’s are in the same directory and I’m the only one around.

I’d appreciate any suggestions as to what I may have missed in the translation,

Cheers,

Reply | Quote

Replies

Andy,

could this be as simple as the database not being in the default Access folder? If so, you’ll need to add the path before the filename, e.g. “D:myfolderfilename,mdb”.

Worth a try.

Reply | Quote

Hi Jules,

Thanks for the quick reply.

Stupid, stupid Access! It should have known what I meant!

Worked Perfectly,

Thanks and Cheers,

Reply | Quote

Andy,

Glad to be of help.

Reply | Quote