View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jan[_11_] Jan[_11_] is offline
external usenet poster
 
Posts: 2
Default Problems opening Access database from Excel VBA

Thank you both. That did the trick :-). An couple off additional question:
What if I do not want to open a form, but just want to display the
database window.
If i remove the OpenForm line, Access is started all right, but nothing is
shown.

And can I test if the database is already open before opening it?

Jan

"Jan Karel Pieterse" wrote in message
...
Hi Jan,

Change your code to:

Sub OpenDatabase()

strdb = "c:\demo.mdb"
Set appAccess = CreateObject("Access.Application")
appAccess.Visible=True
appAccess.OpenCurrentDatabase strdb
appAccess.DoCmd.OpenForm "frmsysteminformation"
Set appAccess = Nothing

End Sub

Sub OpenDatabase()

strdb = "c:\demo.mdb"
Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase strdb
appAccess.DoCmd.OpenForm "frmsysteminformation"
Set appAccess = Nothing

End Sub

This shows the form OK, but not the Access window. When I close the form

it
disappears, but leaves theAccess application running in Background.

How can I open a databae in the database window and gain access, not

only to
the form, but to the full Access, that is Databasewindow and all?


Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com