Phillip,
Thank you for doing that research, but I guess I have not done sucha great
job communicating my scenario.
The way that I am attempting to deploy this backup is through 2 lines of
defense.
the first one, we already know is the ASP.NET app where the user will access
that interface via the browser.
The 2nd line of defense will be (In the same installation package) to have
an Access MDB (encrypted) that resides on each users local machine. This
will be installed to each user's computer.
So the way I want my Web App to work will be to
1) try connecting to the SQL Server - in which case - if it does - Open the
ASP.NET application...
IF it doesn't see the server (the server must be down)
2) ...open the Access MDB that is on their laptop (I don't mean view it in
the browser either - I have written an Access MDB front end version that has
the same interface as the ASP.NET application, but it is a forms application
- so at that point, I would like it to run like one) - I could have gone and
created an ASP page that points to the local MDB, but I figured - why write
that if I already created the prototype in MS Access?
All I need is the syntax for starting a shelled application from the browser
and then for closing down a web app after a local application is started.
Thanks again.
"Phillip Williams" wrote:
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/de.../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!