RE: Opening a MS Access APP - if the SQL connection is not found.

Hi Jonefer,

Running an MS Office component (such as MS Access) through the web means
that the user downloads the database and then run it on their desktop. Here
is an article I found when searching the MSDN that might help you:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp

--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com


"jonefer" wrote:

> Actually the app front end for Access is Access, not an ASP.NET page, so I
> was looking for some sort of a shell call just to open that specific file -
> example: C:\Membership\Member.mdb
>
> (I'm just beginning with ASP.NET so I'm not certain of even a simple call
> like this..)
>
> response.Redirect("c:\Membership\Member.mdb") ???
>
> Thanks.
>
> "Phillip Williams" wrote:
>
> > try
> > Connection to SQL server
> > Catch
> > Response.Redirect("MSAccessPage.aspx")
> > 'will change the browser window display to the application that uses access
> > Finally
> > 'clean up the sql connection variables
> >
> > --
> > HTH,
> > Phillip Williams
> > http://www.societopia.net
> > http://www.webswapp.com
> >
> >
> > "jonefer" wrote:
> >
> > > I have two versions of a 'Downtime Application that will run in the event
> > > that the mainframe goes down
> > > 1) SQL Server ASP.NET app (accessed outside the mainframe network)
> > > 2) MS Access Version of the same app locally installed (C Drive)
> > >
> > >
> > > Can someone help me with the 'Catch' part of this code in VB.NET?
> > >
> > > Pseudo code
> > >
> > > Try...
> > > connection to SQL sever
> > >
> > > Catch
> > > - if the connection is not valid
> > > - open the local MS Access Front end - Version of this application
> > > - close the browser window
> > >
> > > Finally
> > > - close the connection to SQL if there was one..
> > >
> > >
> > > Thanks so much!
.

Relevant Pages

  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... SQL CE/Mobile has a background thread that flushes the changes ... they run for long hours and we have not seen memory leaks so far. ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)
  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... So it is a kind of asynchronous commit which happens every 10 ... I am not sure of this claim as we have many applications built on SQL CE ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)
  • Access 2003 adp/proxy security - A substitute for SYSTEM_USER()
    ... We need a way for SQL to know the nt username that initiated the proxy ... Many stored procedures and views use a UDF that also depends on ... SyUserLogin and use HostIDand HostName() to find the right row. ... We've played with the Connection dialog settings, ...
    (microsoft.public.sqlserver.connect)
  • Access 2003 adp/proxy security - A substitute for SYSTEM_USER()
    ... We need a way for SQL to know the nt username that initiated the proxy ... Many stored procedures and views use a UDF that also depends on ... SyUserLogin and use HostIDand HostName() to find the right row. ... We've played with the Connection dialog settings, ...
    (microsoft.public.access.security)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)