My host wants me store my Access file in a 'data' folder linked using a DSN.

I have set-up the DSN and have this link for it -
d:\websites\domainname\data\database1.mdb

How do I tell Database Access Wizard componet to use this DSN.

Or, is this not possible.

My head is about to expode!!!

Merci

Which type of DSN does your host want you to use, File or System? If System, then the host must set
this up.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Steve Crowther" <(E-Mail Removed)> wrote in message
news:AB03BA66-FB4E-4113-8CA6-(E-Mail Removed)...
> My host wants me store my Access file in a 'data' folder linked using a DSN.
>
> I have set-up the DSN and have this link for it -
> d:\websites\domainname\data\database1.mdb
>
> How do I tell Database Access Wizard componet to use this DSN.
>
> Or, is this not possible.
>
> My head is about to expode!!!
>
> Merci
>
>

The only thing I can 'see' on the setup page is where it says - DSN Type =
Access -

This is on their DSN set-up page, does it help? -

Script access - Each domain is allocated its own unique I_USR account, the
account which permits a web browser to access your web site. This account
also governs access to your database therefore only scripts contained within
a domains web space will have access to your Microsoft Access database.

SGC

"Thomas A. Rowe" wrote:

> Which type of DSN does your host want you to use, File or System? If System, then the host must set
> this up.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> ==============================================
> If you feel your current issue is a results of installing
> a Service Pack or security update, please contact
> Microsoft Product Support Services:
> http://support.microsoft.com
> If the problem can be shown to have been caused by a
> security update, then there is usually no charge for the call.
> ==============================================
>
> "Steve Crowther" <(E-Mail Removed)> wrote in message
> news:AB03BA66-FB4E-4113-8CA6-(E-Mail Removed)...
> > My host wants me store my Access file in a 'data' folder linked using a DSN.
> >
> > I have set-up the DSN and have this link for it -
> > d:\websites\domainname\data\database1.mdb
> >
> > How do I tell Database Access Wizard componet to use this DSN.
> >
> > Or, is this not possible.
> >
> > My head is about to expode!!!
> >
> > Merci
> >
> >
>
>
>

That doesn't really help, you would need to ask them, and then you would need to make your
connection while you have the live/remote site open in FP. You will not be able to connect to the
database from your local copy of your web.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Steve Crowther" <(E-Mail Removed)> wrote in message
news:ECE0EE03-60E1-4611-94AC-(E-Mail Removed)...
> The only thing I can 'see' on the setup page is where it says - DSN Type =
> Access -
>
> This is on their DSN set-up page, does it help? -
>
> Script access - Each domain is allocated its own unique I_USR account, the
> account which permits a web browser to access your web site. This account
> also governs access to your database therefore only scripts contained within
> a domains web space will have access to your Microsoft Access database.
>
> SGC
>
> "Thomas A. Rowe" wrote:
>
>> Which type of DSN does your host want you to use, File or System? If System, then the host must
>> set
>> this up.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "Steve Crowther" <(E-Mail Removed)> wrote in message
>> news:AB03BA66-FB4E-4113-8CA6-(E-Mail Removed)...
>> > My host wants me store my Access file in a 'data' folder linked using a DSN.
>> >
>> > I have set-up the DSN and have this link for it -
>> > d:\websites\domainname\data\database1.mdb
>> >
>> > How do I tell Database Access Wizard componet to use this DSN.
>> >
>> > Or, is this not possible.
>> >
>> > My head is about to expode!!!
>> >
>> > Merci
>> >
>> >
>>
>>
>>

OK

Found out it is a 'System' DSN and it has been set-up.
d:\websites\{domainname}\data\database1.mdb


"Thomas A. Rowe" wrote:

> That doesn't really help, you would need to ask them, and then you would need to make your
> connection while you have the live/remote site open in FP. You will not be able to connect to the
> database from your local copy of your web.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> ==============================================
> If you feel your current issue is a results of installing
> a Service Pack or security update, please contact
> Microsoft Product Support Services:
> http://support.microsoft.com
> If the problem can be shown to have been caused by a
> security update, then there is usually no charge for the call.
> ==============================================
>
> "Steve Crowther" <(E-Mail Removed)> wrote in message
> news:ECE0EE03-60E1-4611-94AC-(E-Mail Removed)...
> > The only thing I can 'see' on the setup page is where it says - DSN Type =
> > Access -
> >
> > This is on their DSN set-up page, does it help? -
> >
> > Script access - Each domain is allocated its own unique I_USR account, the
> > account which permits a web browser to access your web site. This account
> > also governs access to your database therefore only scripts contained within
> > a domains web space will have access to your Microsoft Access database.
> >
> > SGC
> >
> > "Thomas A. Rowe" wrote:
> >
> >> Which type of DSN does your host want you to use, File or System? If System, then the host must
> >> set
> >> this up.
> >>
> >> --
> >> ==============================================
> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> ==============================================
> >> If you feel your current issue is a results of installing
> >> a Service Pack or security update, please contact
> >> Microsoft Product Support Services:
> >> http://support.microsoft.com
> >> If the problem can be shown to have been caused by a
> >> security update, then there is usually no charge for the call.
> >> ==============================================
> >>
> >> "Steve Crowther" <(E-Mail Removed)> wrote in message
> >> news:AB03BA66-FB4E-4113-8CA6-(E-Mail Removed)...
> >> > My host wants me store my Access file in a 'data' folder linked using a DSN.
> >> >
> >> > I have set-up the DSN and have this link for it -
> >> > d:\websites\domainname\data\database1.mdb
> >> >
> >> > How do I tell Database Access Wizard componet to use this DSN.
> >> >
> >> > Or, is this not possible.
> >> >
> >> > My head is about to expode!!!
> >> >
> >> > Merci
> >> >
> >> >
> >>
> >>
> >>
>
>
>

When using a System DSN, the actual location of the database is no longer an issue.

You will have to modify the global.asa file to connect to the System DSN, in the following format:

Application("database1_ConnectionString") = "DSN=SystemDSNName;DRIVER={Microsoft Access Driver
(*.mdb)}"
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Steve Crowther" <(E-Mail Removed)> wrote in message
news:7BEC1486-E9F5-4147-9380-(E-Mail Removed)...
> OK
>
> Found out it is a 'System' DSN and it has been set-up.
> d:\websites\{domainname}\data\database1.mdb
>
>
> "Thomas A. Rowe" wrote:
>
>> That doesn't really help, you would need to ask them, and then you would need to make your
>> connection while you have the live/remote site open in FP. You will not be able to connect to the
>> database from your local copy of your web.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "Steve Crowther" <(E-Mail Removed)> wrote in message
>> news:ECE0EE03-60E1-4611-94AC-(E-Mail Removed)...
>> > The only thing I can 'see' on the setup page is where it says - DSN Type =
>> > Access -
>> >
>> > This is on their DSN set-up page, does it help? -
>> >
>> > Script access - Each domain is allocated its own unique I_USR account, the
>> > account which permits a web browser to access your web site. This account
>> > also governs access to your database therefore only scripts contained within
>> > a domains web space will have access to your Microsoft Access database.
>> >
>> > SGC
>> >
>> > "Thomas A. Rowe" wrote:
>> >
>> >> Which type of DSN does your host want you to use, File or System? If System, then the host
>> >> must
>> >> set
>> >> this up.
>> >>
>> >> --
>> >> ==============================================
>> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> ==============================================
>> >> If you feel your current issue is a results of installing
>> >> a Service Pack or security update, please contact
>> >> Microsoft Product Support Services:
>> >> http://support.microsoft.com
>> >> If the problem can be shown to have been caused by a
>> >> security update, then there is usually no charge for the call.
>> >> ==============================================
>> >>
>> >> "Steve Crowther" <(E-Mail Removed)> wrote in message
>> >> news:AB03BA66-FB4E-4113-8CA6-(E-Mail Removed)...
>> >> > My host wants me store my Access file in a 'data' folder linked using a DSN.
>> >> >
>> >> > I have set-up the DSN and have this link for it -
>> >> > d:\websites\domainname\data\database1.mdb
>> >> >
>> >> > How do I tell Database Access Wizard componet to use this DSN.
>> >> >
>> >> > Or, is this not possible.
>> >> >
>> >> > My head is about to expode!!!
>> >> >
>> >> > Merci
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

Hi,

Would it be formed like this -

Application("database1_ConnectionString") =
"DSN=d:\websites\domainname\data\database1.mdb
;DRIVER={Microsoft Access Driver
(*.mdb)}"

SGC



"Thomas A. Rowe" wrote:

> When using a System DSN, the actual location of the database is no longer an issue.
>
> You will have to modify the global.asa file to connect to the System DSN, in the following format:
>
> Application("database1_ConnectionString") = "DSN=SystemDSNName;DRIVER={Microsoft Access Driver
> (*.mdb)}"
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> ==============================================
> If you feel your current issue is a results of installing
> a Service Pack or security update, please contact
> Microsoft Product Support Services:
> http://support.microsoft.com
> If the problem can be shown to have been caused by a
> security update, then there is usually no charge for the call.
> ==============================================
>
> "Steve Crowther" <(E-Mail Removed)> wrote in message
> news:7BEC1486-E9F5-4147-9380-(E-Mail Removed)...
> > OK
> >
> > Found out it is a 'System' DSN and it has been set-up.
> > d:\websites\{domainname}\data\database1.mdb
> >
> >
> > "Thomas A. Rowe" wrote:
> >
> >> That doesn't really help, you would need to ask them, and then you would need to make your
> >> connection while you have the live/remote site open in FP. You will not be able to connect to the
> >> database from your local copy of your web.
> >>
> >> --
> >> ==============================================
> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> ==============================================
> >> If you feel your current issue is a results of installing
> >> a Service Pack or security update, please contact
> >> Microsoft Product Support Services:
> >> http://support.microsoft.com
> >> If the problem can be shown to have been caused by a
> >> security update, then there is usually no charge for the call.
> >> ==============================================
> >>
> >> "Steve Crowther" <(E-Mail Removed)> wrote in message
> >> news:ECE0EE03-60E1-4611-94AC-(E-Mail Removed)...
> >> > The only thing I can 'see' on the setup page is where it says - DSN Type =
> >> > Access -
> >> >
> >> > This is on their DSN set-up page, does it help? -
> >> >
> >> > Script access - Each domain is allocated its own unique I_USR account, the
> >> > account which permits a web browser to access your web site. This account
> >> > also governs access to your database therefore only scripts contained within
> >> > a domains web space will have access to your Microsoft Access database.
> >> >
> >> > SGC
> >> >
> >> > "Thomas A. Rowe" wrote:
> >> >
> >> >> Which type of DSN does your host want you to use, File or System? If System, then the host
> >> >> must
> >> >> set
> >> >> this up.
> >> >>
> >> >> --
> >> >> ==============================================
> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> >> ==============================================
> >> >> If you feel your current issue is a results of installing
> >> >> a Service Pack or security update, please contact
> >> >> Microsoft Product Support Services:
> >> >> http://support.microsoft.com
> >> >> If the problem can be shown to have been caused by a
> >> >> security update, then there is usually no charge for the call.
> >> >> ==============================================
> >> >>
> >> >> "Steve Crowther" <(E-Mail Removed)> wrote in message
> >> >> news:AB03BA66-FB4E-4113-8CA6-(E-Mail Removed)...
> >> >> > My host wants me store my Access file in a 'data' folder linked using a DSN.
> >> >> >
> >> >> > I have set-up the DSN and have this link for it -
> >> >> > d:\websites\domainname\data\database1.mdb
> >> >> >
> >> >> > How do I tell Database Access Wizard componet to use this DSN.
> >> >> >
> >> >> > Or, is this not possible.
> >> >> >
> >> >> > My head is about to expode!!!
> >> >> >
> >> >> > Merci
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

What you have indicated below is File DSN.

When using a System DSN, the name/path to the database is never part of the connection string, see
my original example posted below

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Steve Crowther" <(E-Mail Removed)> wrote in message
news:F20C7C44-D9B9-4EEF-988B-(E-Mail Removed)...
> Hi,
>
> Would it be formed like this -
>
> Application("database1_ConnectionString") =
> "DSN=d:\websites\domainname\data\database1.mdb
> ;DRIVER={Microsoft Access Driver
> (*.mdb)}"
>
> SGC
>
>
>
> "Thomas A. Rowe" wrote:
>
>> When using a System DSN, the actual location of the database is no longer an issue.
>>
>> You will have to modify the global.asa file to connect to the System DSN, in the following
>> format:
>>
>> Application("database1_ConnectionString") = "DSN=SystemDSNName;DRIVER={Microsoft Access Driver
>> (*.mdb)}"
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "Steve Crowther" <(E-Mail Removed)> wrote in message
>> news:7BEC1486-E9F5-4147-9380-(E-Mail Removed)...
>> > OK
>> >
>> > Found out it is a 'System' DSN and it has been set-up.
>> > d:\websites\{domainname}\data\database1.mdb
>> >
>> >
>> > "Thomas A. Rowe" wrote:
>> >
>> >> That doesn't really help, you would need to ask them, and then you would need to make your
>> >> connection while you have the live/remote site open in FP. You will not be able to connect to
>> >> the
>> >> database from your local copy of your web.
>> >>
>> >> --
>> >> ==============================================
>> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> ==============================================
>> >> If you feel your current issue is a results of installing
>> >> a Service Pack or security update, please contact
>> >> Microsoft Product Support Services:
>> >> http://support.microsoft.com
>> >> If the problem can be shown to have been caused by a
>> >> security update, then there is usually no charge for the call.
>> >> ==============================================
>> >>
>> >> "Steve Crowther" <(E-Mail Removed)> wrote in message
>> >> news:ECE0EE03-60E1-4611-94AC-(E-Mail Removed)...
>> >> > The only thing I can 'see' on the setup page is where it says - DSN Type =
>> >> > Access -
>> >> >
>> >> > This is on their DSN set-up page, does it help? -
>> >> >
>> >> > Script access - Each domain is allocated its own unique I_USR account, the
>> >> > account which permits a web browser to access your web site. This account
>> >> > also governs access to your database therefore only scripts contained within
>> >> > a domains web space will have access to your Microsoft Access database.
>> >> >
>> >> > SGC
>> >> >
>> >> > "Thomas A. Rowe" wrote:
>> >> >
>> >> >> Which type of DSN does your host want you to use, File or System? If System, then the host
>> >> >> must
>> >> >> set
>> >> >> this up.
>> >> >>
>> >> >> --
>> >> >> ==============================================
>> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> >> ==============================================
>> >> >> If you feel your current issue is a results of installing
>> >> >> a Service Pack or security update, please contact
>> >> >> Microsoft Product Support Services:
>> >> >> http://support.microsoft.com
>> >> >> If the problem can be shown to have been caused by a
>> >> >> security update, then there is usually no charge for the call.
>> >> >> ==============================================
>> >> >>
>> >> >> "Steve Crowther" <(E-Mail Removed)> wrote in message
>> >> >> news:AB03BA66-FB4E-4113-8CA6-(E-Mail Removed)...
>> >> >> > My host wants me store my Access file in a 'data' folder linked using a DSN.
>> >> >> >
>> >> >> > I have set-up the DSN and have this link for it -
>> >> >> > d:\websites\domainname\data\database1.mdb
>> >> >> >
>> >> >> > How do I tell Database Access Wizard componet to use this DSN.
>> >> >> >
>> >> >> > Or, is this not possible.
>> >> >> >
>> >> >> > My head is about to expode!!!
>> >> >> >
>> >> >> > Merci
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

Why can't technical people (who know) ever give a straight, simple answer?

Why does everything have to be shrouded in mystery?

Can you please, please give me how the line would look and how I then tell
the Database Access Wizard to use this?

I'm begging for help here....

SGC

"Thomas A. Rowe" wrote:

> What you have indicated below is File DSN.
>
> When using a System DSN, the name/path to the database is never part of the connection string, see
> my original example posted below
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> ==============================================
> If you feel your current issue is a results of installing
> a Service Pack or security update, please contact
> Microsoft Product Support Services:
> http://support.microsoft.com
> If the problem can be shown to have been caused by a
> security update, then there is usually no charge for the call.
> ==============================================
>
> "Steve Crowther" <(E-Mail Removed)> wrote in message
> news:F20C7C44-D9B9-4EEF-988B-(E-Mail Removed)...
> > Hi,
> >
> > Would it be formed like this -
> >
> > Application("database1_ConnectionString") =
> > "DSN=d:\websites\domainname\data\database1.mdb
> > ;DRIVER={Microsoft Access Driver
> > (*.mdb)}"
> >
> > SGC
> >
> >
> >
> > "Thomas A. Rowe" wrote:
> >
> >> When using a System DSN, the actual location of the database is no longer an issue.
> >>
> >> You will have to modify the global.asa file to connect to the System DSN, in the following
> >> format:
> >>
> >> Application("database1_ConnectionString") = "DSN=SystemDSNName;DRIVER={Microsoft Access Driver
> >> (*.mdb)}"
> >> --
> >> ==============================================
> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> ==============================================
> >> If you feel your current issue is a results of installing
> >> a Service Pack or security update, please contact
> >> Microsoft Product Support Services:
> >> http://support.microsoft.com
> >> If the problem can be shown to have been caused by a
> >> security update, then there is usually no charge for the call.
> >> ==============================================
> >>
> >> "Steve Crowther" <(E-Mail Removed)> wrote in message
> >> news:7BEC1486-E9F5-4147-9380-(E-Mail Removed)...
> >> > OK
> >> >
> >> > Found out it is a 'System' DSN and it has been set-up.
> >> > d:\websites\{domainname}\data\database1.mdb
> >> >
> >> >
> >> > "Thomas A. Rowe" wrote:
> >> >
> >> >> That doesn't really help, you would need to ask them, and then you would need to make your
> >> >> connection while you have the live/remote site open in FP. You will not be able to connect to
> >> >> the
> >> >> database from your local copy of your web.
> >> >>
> >> >> --
> >> >> ==============================================
> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> >> ==============================================
> >> >> If you feel your current issue is a results of installing
> >> >> a Service Pack or security update, please contact
> >> >> Microsoft Product Support Services:
> >> >> http://support.microsoft.com
> >> >> If the problem can be shown to have been caused by a
> >> >> security update, then there is usually no charge for the call.
> >> >> ==============================================
> >> >>
> >> >> "Steve Crowther" <(E-Mail Removed)> wrote in message
> >> >> news:ECE0EE03-60E1-4611-94AC-(E-Mail Removed)...
> >> >> > The only thing I can 'see' on the setup page is where it says - DSN Type =
> >> >> > Access -
> >> >> >
> >> >> > This is on their DSN set-up page, does it help? -
> >> >> >
> >> >> > Script access - Each domain is allocated its own unique I_USR account, the
> >> >> > account which permits a web browser to access your web site. This account
> >> >> > also governs access to your database therefore only scripts contained within
> >> >> > a domains web space will have access to your Microsoft Access database.
> >> >> >
> >> >> > SGC
> >> >> >
> >> >> > "Thomas A. Rowe" wrote:
> >> >> >
> >> >> >> Which type of DSN does your host want you to use, File or System? If System, then the host
> >> >> >> must
> >> >> >> set
> >> >> >> this up.
> >> >> >>
> >> >> >> --
> >> >> >> ==============================================
> >> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> >> >> ==============================================
> >> >> >> If you feel your current issue is a results of installing
> >> >> >> a Service Pack or security update, please contact
> >> >> >> Microsoft Product Support Services:
> >> >> >> http://support.microsoft.com
> >> >> >> If the problem can be shown to have been caused by a
> >> >> >> security update, then there is usually no charge for the call.
> >> >> >> ==============================================
> >> >> >>
> >> >> >> "Steve Crowther" <(E-Mail Removed)> wrote in message
> >> >> >> news:AB03BA66-FB4E-4113-8CA6-(E-Mail Removed)...
> >> >> >> > My host wants me store my Access file in a 'data' folder linked using a DSN.
> >> >> >> >
> >> >> >> > I have set-up the DSN and have this link for it -
> >> >> >> > d:\websites\domainname\data\database1.mdb
> >> >> >> >
> >> >> >> > How do I tell Database Access Wizard componet to use this DSN.
> >> >> >> >
> >> >> >> > Or, is this not possible.
> >> >> >> >
> >> >> >> > My head is about to expode!!!
> >> >> >> >
> >> >> >> > Merci
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

This is how the line would look when using a System DSN, as I original posted:

Application("database1_ConnectionString") = "DSN=SystemDSNName;DRIVER={Microsoft Access Driver
(*.mdb)}"

Note: SystemDSNName = is the System DSN Name you host (control panel) has assigned to your database.

You may have to manual write or modify a global.asa file, you will not be able to use the FP
Database component, unless you have you live/remote site open in FP and your web host allows you to
see/select your System DSN from a list of System DSNs on the server, most host do not allow this for
security reasons.


--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Steve Crowther" <(E-Mail Removed)> wrote in message
news:C0875F22-466F-47D2-9180-(E-Mail Removed)...
> Why can't technical people (who know) ever give a straight, simple answer?
>
> Why does everything have to be shrouded in mystery?
>
> Can you please, please give me how the line would look and how I then tell
> the Database Access Wizard to use this?
>
> I'm begging for help here....
>
> SGC
>
> "Thomas A. Rowe" wrote:
>
>> What you have indicated below is File DSN.
>>
>> When using a System DSN, the name/path to the database is never part of the connection string,
>> see
>> my original example posted below
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "Steve Crowther" <(E-Mail Removed)> wrote in message
>> news:F20C7C44-D9B9-4EEF-988B-(E-Mail Removed)...
>> > Hi,
>> >
>> > Would it be formed like this -
>> >
>> > Application("database1_ConnectionString") =
>> > "DSN=d:\websites\domainname\data\database1.mdb
>> > ;DRIVER={Microsoft Access Driver
>> > (*.mdb)}"
>> >
>> > SGC
>> >
>> >
>> >
>> > "Thomas A. Rowe" wrote:
>> >
>> >> When using a System DSN, the actual location of the database is no longer an issue.
>> >>
>> >> You will have to modify the global.asa file to connect to the System DSN, in the following
>> >> format:
>> >>
>> >> Application("database1_ConnectionString") = "DSN=SystemDSNName;DRIVER={Microsoft Access Driver
>> >> (*.mdb)}"
>> >> --
>> >> ==============================================
>> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> ==============================================
>> >> If you feel your current issue is a results of installing
>> >> a Service Pack or security update, please contact
>> >> Microsoft Product Support Services:
>> >> http://support.microsoft.com
>> >> If the problem can be shown to have been caused by a
>> >> security update, then there is usually no charge for the call.
>> >> ==============================================
>> >>
>> >> "Steve Crowther" <(E-Mail Removed)> wrote in message
>> >> news:7BEC1486-E9F5-4147-9380-(E-Mail Removed)...
>> >> > OK
>> >> >
>> >> > Found out it is a 'System' DSN and it has been set-up.
>> >> > d:\websites\{domainname}\data\database1.mdb
>> >> >
>> >> >
>> >> > "Thomas A. Rowe" wrote:
>> >> >
>> >> >> That doesn't really help, you would need to ask them, and then you would need to make your
>> >> >> connection while you have the live/remote site open in FP. You will not be able to connect
>> >> >> to
>> >> >> the
>> >> >> database from your local copy of your web.
>> >> >>
>> >> >> --
>> >> >> ==============================================
>> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> >> ==============================================
>> >> >> If you feel your current issue is a results of installing
>> >> >> a Service Pack or security update, please contact
>> >> >> Microsoft Product Support Services:
>> >> >> http://support.microsoft.com
>> >> >> If the problem can be shown to have been caused by a
>> >> >> security update, then there is usually no charge for the call.
>> >> >> ==============================================
>> >> >>
>> >> >> "Steve Crowther" <(E-Mail Removed)> wrote in message
>> >> >> news:ECE0EE03-60E1-4611-94AC-(E-Mail Removed)...
>> >> >> > The only thing I can 'see' on the setup page is where it says - DSN Type =
>> >> >> > Access -
>> >> >> >
>> >> >> > This is on their DSN set-up page, does it help? -
>> >> >> >
>> >> >> > Script access - Each domain is allocated its own unique I_USR account, the
>> >> >> > account which permits a web browser to access your web site. This account
>> >> >> > also governs access to your database therefore only scripts contained within
>> >> >> > a domains web space will have access to your Microsoft Access database.
>> >> >> >
>> >> >> > SGC
>> >> >> >
>> >> >> > "Thomas A. Rowe" wrote:
>> >> >> >
>> >> >> >> Which type of DSN does your host want you to use, File or System? If System, then the
>> >> >> >> host
>> >> >> >> must
>> >> >> >> set
>> >> >> >> this up.
>> >> >> >>
>> >> >> >> --
>> >> >> >> ==============================================
>> >> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> >> >> ==============================================
>> >> >> >> If you feel your current issue is a results of installing
>> >> >> >> a Service Pack or security update, please contact
>> >> >> >> Microsoft Product Support Services:
>> >> >> >> http://support.microsoft.com
>> >> >> >> If the problem can be shown to have been caused by a
>> >> >> >> security update, then there is usually no charge for the call.
>> >> >> >> ==============================================
>> >> >> >>
>> >> >> >> "Steve Crowther" <(E-Mail Removed)> wrote in message
>> >> >> >> news:AB03BA66-FB4E-4113-8CA6-(E-Mail Removed)...
>> >> >> >> > My host wants me store my Access file in a 'data' folder linked using a DSN.
>> >> >> >> >
>> >> >> >> > I have set-up the DSN and have this link for it -
>> >> >> >> > d:\websites\domainname\data\database1.mdb
>> >> >> >> >
>> >> >> >> > How do I tell Database Access Wizard componet to use this DSN.
>> >> >> >> >
>> >> >> >> > Or, is this not possible.
>> >> >> >> >
>> >> >> >> > My head is about to expode!!!
>> >> >> >> >
>> >> >> >> > Merci
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>