Starting Access using VBA

[DHIGHTO]

Hey guys,



I'm trying to start an existing Access db using vba in Excel. The code I'm running will start the db, but the db immediately closes. Here is my code

Sub Example1()
 'Access object
Dim appAccess As Object
'create new access object
Set appAccess = CreateObject("Access.Application")
 'open the accesS project
Call appAccess.OpenCurrentDatabase( _
 "C:\user\AR DAILY REPORT.ACCDB")
  appAccess.Visible = True
End Sub

I can't figure out what is wrong.

Thanks,

[Rawb]

Try opening a Form in your code. If you only have the Access Runtime, it's possible the program may see that you don't have any open objects (Forms or Reports) and is closing itself.

[DHIGHTO]

Thanks! It worked!

[rpeare]

Try this:

http://stackoverflow.com/questions/1...from-excel-vba

look at the last post