navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
FrontPage Alternative
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Free FrontPage Templates

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

Run Macro

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Run Macro
Page: [1]
 
accessman

 

Posts: 74
Joined: 9/13/2005
Status: offline

 
Run Macro - 7/15/2006 22:00:51   
<%

Set objAccess = Server.CreateObject("Access.Application")
objAccess.Visible = False

objAccess.OpenCurrentDatabase "c:\db1.mdb"

Set objDB = objAccess.CurrentDb()

macroName = "Macro1"

objAccess.DoCmd.RunMacro macroName


set objDB = nothing
objAccess.Quit acQuitSaveNone
Set objAccess = Nothing

Response.Write "Your macro has been run!"
%>

Why the line code has an error: objAccess.OpenCurrentDatabase "c:\db1.mdb"

Error Type:
(0x800A1EBA)
/asp_db1/runmacro.asp, line 8

How to solve it?

Thanks.
yb2

 

Posts: 653
Joined: 1/30/2006
Status: offline

 
RE: Run Macro - 7/17/2006 4:24:17   
Hi

read this
http://www.4guysfromrolla.com/webtech/121799-1.shtml

_____________________________

it is natural for people not to see one's own faults, and to exaggerate other people's faults and failings.
Currently listening to: L'Enfer Des Formes by Stereolab

(in reply to accessman)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Run Macro
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts