Re: Close Access From An ASP Page

Tech-Archive recommends: Fix windows errors by optimizing your registry



"Bob Barrows [MVP]" wrote:

> Bob Barrows [MVP] wrote:
> > Bill Barber wrote:
> >> I have the following code in Which I must Open Access, run a Macro
> >> and then Close Access. The Problem is that this code is not closing
> >> Access. Windows XP with Office 2000 and the latest Service Packs
> >> have been installed
> >>
> >>
> >> Set objAccess = Server.CreateObject("Access.Application")
> >
> > I assume you've read all the caveats about automating Office
> > applications in server code:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;257757
> >
> >> objAccess.Visible = False
> >> objAccess.OpenCurrentDatabase
> >> "C:\INetPub\wwwRoot\Remote\MyDatabase.mdb" objAccess.DoCmd.RunMacro
> >> "NameOfMacro"
> >> objAccess.CloseCurrentDatabase
> >> objAccess.Quit 2 ' 2 = acQuitSaveNone
> >> Set objAccess = Nothing
> >>
> >> Does anyone know what I am doing Wrong?
> >>
> > Try leaving the application visible. Are you getting the Security
> > Warning dialog when the database opens? There is nobody to respond to
> > that dialog on the server ...
>
> If you are getting the security warning dialog, you can disable it by
> setting the security level to Low in Tools|Macros|Security
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>

I am not getting the warning, any student has access to the server.
.

Relevant Pages

  • Re: SP 3s Warning: "The server you are connected to is uding a security certificate that cannot be v
    ... MS MVP-IE, Mail, Security, Windows Desktop Experience - since 2002 ... DTS-L http://dts-l.net/ ... How can I stop this warning! ... The server is an ATT IP server over which I ...
    (microsoft.public.windowsxp.general)
  • Web server SSL certificate not quite right
    ... service under .NET Server 2003 RC1. ... there is a problem with the site's security certificate. ... Anyone have any details on how to get rid of the warning? ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • configure PHP4 for PHP on IIS6 using SQL 2000 ?
    ... I have installed a PHP SQL application named "Shop-Scripts" on IIS6. ... allow PHP to work on IIS6 with SQL SERVER 2000 (assuming this was the ... A warning appears if the specified function is not defined, ... Setting certain environment variables may be a potential security breach. ...
    (microsoft.public.inetserver.iis)
  • RE: Server Application Unavailable
    ... Did you check with the web server if it is running and the WWW Service? ... > I default have all servers setup with scripts and they are all Exact alike ... > Open Access: All ...
    (microsoft.public.dotnet.framework)
  • Server Application Unavailable
    ... i have a critical problem regarding dotnet on that server. ... 61 4:15:39 PM w3wp.exe:3288 QUERY INFORMATION ... Open Access: All ...
    (microsoft.public.dotnet.framework)