Calling Access 1

[AgentM]

How can I call an Access Application from VBScript.

I can open the *.mdb file but it doesn't stay open.
my code:
Set AApp = GetObject("C:/db1.mdb","Access Application&quot
AApp.Visible = true

It opens and closes doesn't stay open .
Any ideas.

 

[link9]

Here's a FAQ on how to connect to an Access database:

faq333-178

and check out

http://www.learnasp.com

http://www.4guysfromrolla.com

for some excellent tutorials and

http://www.devguru.com

for great quick ref material.

good luck!
Paul Prewett

 

[AgentM]

Thanks Paul

I don't want to connect to Access. I want the user to Open a Access db when a link is clicked on an internet page.

Say using GetObject or CreateObject.

Thank you for the response.

 

[tsuji]

Hello, AgentM.

Here is the revision you should have.

Set AApp = GetObject("C:\db1.mdb","Access.Application&quot
With AApp
.Visible = true
.UserControl = true
End With

regards - tsuji

PS I don't know whether it is a typo of yours or not. "Access.Application" should have a dot in between.