Open Access, then database?

[James T.]

Access 2000

I have been able to open Word and Excell using this type
of code, but trying it with access will open the app, but
not the data. With Word it is:

' Open the document.
..Documents.open(path ...)

But I don't know what replaces "documents" in trying to do
it with access.

Option Compare Database

Private Sub Command0_Click()

' start Microsoft Access.
Set accessapp = CreateObject("access.application")

With accessapp

' Make the application visible.
.Visible = True
' Open the document.
.?????????.Open ("j:\etc...\MERGForms.mdb")

End With

End Sub

Anyone know?

Thanks!

James

 

[Gerald Stanley]

Try

With accessapp

' Make the application visible.
.Visible = True
' Open the document.
.OpenCurrentDatabase("j:\etc...\MERGForms.mdb")

End With

Hope This Helps
Gerald Stanley MCSD

 

[James T.]

Gerald,

Thanks! That did it. Now I have three, Word, Excel and
Access.

James