Changing Global.asa

[Brian Royston]

What I would like to do is change the Global.asa file connection string from

'==FrontPage Generated - startspan==
Dim FrontPage_UrlVars(1)
'--Project Data Connection
Application("aspprotect_ConnectionString") = "DRIVER={Microsoft Access
Driver (*.mdb)};DBQ=URL=fpdb/Registration.mdb"
FrontPage_UrlVars(0) = "Registration._ConnectionString"
Application("Registration._ConnectionTimeout") = 15
Application("Registration._CommandTimeout") = 30
Application("Registration._CursorLocation") = 3
Application("Registration._RuntimeUserName") = ""
Application("Registration._RuntimePassword") = ""
'--
Application("FrontPage_UrlVars") = FrontPage_UrlVars
'==FrontPage Generated - endspan==



To
ConnectionString = Application("Registration._ConnectionString")

'==FrontPage Generated - startspan==
Dim FrontPage_UrlVars(1)
'--Project Data Connection

ConnectionString = Application("Registration._ConnectionString")
FrontPage_UrlVars(0) = "Registration._ConnectionString"
Application("Registration._ConnectionTimeout") = 15
Application("Registration._CommandTimeout") = 30
Application("Registration._CursorLocation") = 3
Application("Registration._RuntimeUserName") = ""
Application("Registration._RuntimePassword") = ""
'--
Application("FrontPage_UrlVars") = FrontPage_UrlVars
'==FrontPage Generated - endspan==



So that I can make better use of the inbuilt database wizards from a subweb?

Is there anything else I need to do to get this to work?

 

[Thomas A. Rowe]

Just change it, how then you can not use FP to create/verify the connection, as it will correct the
file. FP will not create database connections that cross webs / subwebs

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================