Re: Close Access From An ASP Page

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



"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 ...
>
> --
> 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"
>
The server is used for Homework Assignments, there is very little on it. I
do understand the hazzards.

Tried both ideas, No Go. This has been driving me crazy. It worked at one
time and then something happened.
>
.

Relevant Pages

  • Re: Close Access From An ASP Page
    ... > I have the following code in Which I must Open Access, ... I assume you've read all the caveats about automating Office applications in ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Close Access From An ASP Page
    ... >> I have the following code in Which I must Open Access, ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • 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)
  • Re: Close Access From An ASP Page
    ... >>> I have the following code in Which I must Open Access, ... Are you getting the Security ... >> that dialog on the server ... ... > If you are getting the security warning dialog, ...
    (microsoft.public.scripting.vbscript)