Hi I have my .mdb on a web server and in FrontPage I am trying to connect to
it so I can create my forms. First, is there anything I need to check on the
server itself as far as ODBC drivers, etc.. to allow Frontpage to connect?
Second I am following FrontPage's instructions to connect by - Database
Connections > Add a Catalog > Configure Database Connection > Server Name
(this is a bit confusing) because my server name is //srvwch16/d$, am I
missing something here? Then Username and Password and when I click next and
I get this huge error message stating that "an error occured while retrieving
a list of Databases. An authentication error occured, Your logon....."

Any ideas, I really need to get this working?

Thanks, Chris A

Re: Please Help with Database Connection by Thomas

Thomas
Thu Oct 27 07:48:33 CDT 2005

Import the database into FP, create a connection name and let FP move it to the fpdb folder.

--
==============================================
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.
==============================================

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:9F8BBF73-5EE8-462C-AA76-2CD4FF3EE4C4@microsoft.com...
> Hi I have my .mdb on a web server and in FrontPage I am trying to connect to
> it so I can create my forms. First, is there anything I need to check on the
> server itself as far as ODBC drivers, etc.. to allow Frontpage to connect?
> Second I am following FrontPage's instructions to connect by - Database
> Connections > Add a Catalog > Configure Database Connection > Server Name
> (this is a bit confusing) because my server name is //srvwch16/d$, am I
> missing something here? Then Username and Password and when I click next and
> I get this huge error message stating that "an error occured while retrieving
> a list of Databases. An authentication error occured, Your logon....."
>
> Any ideas, I really need to get this working?
>
> Thanks, Chris A



Re: Please Help with Database Connection by Chris

Chris
Thu Oct 27 07:55:08 CDT 2005

So basically I would do a file > import, choose the .mdb, etc..?

CA

"Thomas A. Rowe" wrote:

> Import the database into FP, create a connection name and let FP move it to the fpdb folder.
>
> --
> ==============================================
> 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.
> ==============================================
>
> "Chris" <Chris@discussions.microsoft.com> wrote in message
> news:9F8BBF73-5EE8-462C-AA76-2CD4FF3EE4C4@microsoft.com...
> > Hi I have my .mdb on a web server and in FrontPage I am trying to connect to
> > it so I can create my forms. First, is there anything I need to check on the
> > server itself as far as ODBC drivers, etc.. to allow Frontpage to connect?
> > Second I am following FrontPage's instructions to connect by - Database
> > Connections > Add a Catalog > Configure Database Connection > Server Name
> > (this is a bit confusing) because my server name is //srvwch16/d$, am I
> > missing something here? Then Username and Password and when I click next and
> > I get this huge error message stating that "an error occured while retrieving
> > a list of Databases. An authentication error occured, Your logon....."
> >
> > Any ideas, I really need to get this working?
> >
> > Thanks, Chris A
>
>
>

Re: Please Help with Database Connection by Thomas

Thomas
Thu Oct 27 08:19:26 CDT 2005

Just drag-n-drop the database into your current open FP 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.
==============================================

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:1D407A8E-2E9A-4F30-AF25-46293D7101CA@microsoft.com...
> So basically I would do a file > import, choose the .mdb, etc..?
>
> CA
>
> "Thomas A. Rowe" wrote:
>
>> Import the database into FP, create a connection name and let FP move it to the fpdb folder.
>>
>> --
>> ==============================================
>> 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.
>> ==============================================
>>
>> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> news:9F8BBF73-5EE8-462C-AA76-2CD4FF3EE4C4@microsoft.com...
>> > Hi I have my .mdb on a web server and in FrontPage I am trying to connect to
>> > it so I can create my forms. First, is there anything I need to check on the
>> > server itself as far as ODBC drivers, etc.. to allow Frontpage to connect?
>> > Second I am following FrontPage's instructions to connect by - Database
>> > Connections > Add a Catalog > Configure Database Connection > Server Name
>> > (this is a bit confusing) because my server name is //srvwch16/d$, am I
>> > missing something here? Then Username and Password and when I click next and
>> > I get this huge error message stating that "an error occured while retrieving
>> > a list of Databases. An authentication error occured, Your logon....."
>> >
>> > Any ideas, I really need to get this working?
>> >
>> > Thanks, Chris A
>>
>>
>>



Re: Please Help with Database Connection by Chris

Chris
Thu Oct 27 08:20:07 CDT 2005

Is there a way I can test this on my local machine? Do I need to have IIS
installed? I have tried this by copying the .mdb file to my local harddrive
and importing it but I continue to get this permissions dialog box stating
that I do not have permissions. Now why would it way that on my own computer?

CA

"Chris" wrote:

> So basically I would do a file > import, choose the .mdb, etc..?
>
> CA
>
> "Thomas A. Rowe" wrote:
>
> > Import the database into FP, create a connection name and let FP move it to the fpdb folder.
> >
> > --
> > ==============================================
> > 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.
> > ==============================================
> >
> > "Chris" <Chris@discussions.microsoft.com> wrote in message
> > news:9F8BBF73-5EE8-462C-AA76-2CD4FF3EE4C4@microsoft.com...
> > > Hi I have my .mdb on a web server and in FrontPage I am trying to connect to
> > > it so I can create my forms. First, is there anything I need to check on the
> > > server itself as far as ODBC drivers, etc.. to allow Frontpage to connect?
> > > Second I am following FrontPage's instructions to connect by - Database
> > > Connections > Add a Catalog > Configure Database Connection > Server Name
> > > (this is a bit confusing) because my server name is //srvwch16/d$, am I
> > > missing something here? Then Username and Password and when I click next and
> > > I get this huge error message stating that "an error occured while retrieving
> > > a list of Databases. An authentication error occured, Your logon....."
> > >
> > > Any ideas, I really need to get this working?
> > >
> > > Thanks, Chris A
> >
> >
> >

Re: Please Help with Database Connection by Chris

Chris
Thu Oct 27 08:29:06 CDT 2005

Thomas, I am not 100% familiar with how FP works so what do you mean by
"current open FP web"?

CA

"Thomas A. Rowe" wrote:

> Just drag-n-drop the database into your current open FP 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.
> ==============================================
>
> "Chris" <Chris@discussions.microsoft.com> wrote in message
> news:1D407A8E-2E9A-4F30-AF25-46293D7101CA@microsoft.com...
> > So basically I would do a file > import, choose the .mdb, etc..?
> >
> > CA
> >
> > "Thomas A. Rowe" wrote:
> >
> >> Import the database into FP, create a connection name and let FP move it to the fpdb folder.
> >>
> >> --
> >> ==============================================
> >> 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.
> >> ==============================================
> >>
> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> >> news:9F8BBF73-5EE8-462C-AA76-2CD4FF3EE4C4@microsoft.com...
> >> > Hi I have my .mdb on a web server and in FrontPage I am trying to connect to
> >> > it so I can create my forms. First, is there anything I need to check on the
> >> > server itself as far as ODBC drivers, etc.. to allow Frontpage to connect?
> >> > Second I am following FrontPage's instructions to connect by - Database
> >> > Connections > Add a Catalog > Configure Database Connection > Server Name
> >> > (this is a bit confusing) because my server name is //srvwch16/d$, am I
> >> > missing something here? Then Username and Password and when I click next and
> >> > I get this huge error message stating that "an error occured while retrieving
> >> > a list of Databases. An authentication error occured, Your logon....."
> >> >
> >> > Any ideas, I really need to get this working?
> >> >
> >> > Thanks, Chris A
> >>
> >>
> >>
>
>
>

Re: Please Help with Database Connection by Thomas

Thomas
Thu Oct 27 08:42:51 CDT 2005

File Menu | Open web / site

Do this first, whenever you need to work on your web content.

--
==============================================
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.
==============================================

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:CB310096-B59F-43D4-9C30-912F59946DA0@microsoft.com...
> Thomas, I am not 100% familiar with how FP works so what do you mean by
> "current open FP web"?
>
> CA
>
> "Thomas A. Rowe" wrote:
>
>> Just drag-n-drop the database into your current open FP 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.
>> ==============================================
>>
>> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> news:1D407A8E-2E9A-4F30-AF25-46293D7101CA@microsoft.com...
>> > So basically I would do a file > import, choose the .mdb, etc..?
>> >
>> > CA
>> >
>> > "Thomas A. Rowe" wrote:
>> >
>> >> Import the database into FP, create a connection name and let FP move it to the fpdb folder.
>> >>
>> >> --
>> >> ==============================================
>> >> 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.
>> >> ==============================================
>> >>
>> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> >> news:9F8BBF73-5EE8-462C-AA76-2CD4FF3EE4C4@microsoft.com...
>> >> > Hi I have my .mdb on a web server and in FrontPage I am trying to connect to
>> >> > it so I can create my forms. First, is there anything I need to check on the
>> >> > server itself as far as ODBC drivers, etc.. to allow Frontpage to connect?
>> >> > Second I am following FrontPage's instructions to connect by - Database
>> >> > Connections > Add a Catalog > Configure Database Connection > Server Name
>> >> > (this is a bit confusing) because my server name is //srvwch16/d$, am I
>> >> > missing something here? Then Username and Password and when I click next and
>> >> > I get this huge error message stating that "an error occured while retrieving
>> >> > a list of Databases. An authentication error occured, Your logon....."
>> >> >
>> >> > Any ideas, I really need to get this working?
>> >> >
>> >> > Thanks, Chris A
>> >>
>> >>
>> >>
>>
>>
>>



Re: Please Help with Database Connection by Thomas

Thomas
Thu Oct 27 08:41:59 CDT 2005

You have to have IIS and the FP extensions installed and then create/access the site via
http://localhost

--
==============================================
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.
==============================================

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:D782FA37-EDA6-4262-A437-87853D534149@microsoft.com...
> Is there a way I can test this on my local machine? Do I need to have IIS
> installed? I have tried this by copying the .mdb file to my local harddrive
> and importing it but I continue to get this permissions dialog box stating
> that I do not have permissions. Now why would it way that on my own computer?
>
> CA
>
> "Chris" wrote:
>
>> So basically I would do a file > import, choose the .mdb, etc..?
>>
>> CA
>>
>> "Thomas A. Rowe" wrote:
>>
>> > Import the database into FP, create a connection name and let FP move it to the fpdb folder.
>> >
>> > --
>> > ==============================================
>> > 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.
>> > ==============================================
>> >
>> > "Chris" <Chris@discussions.microsoft.com> wrote in message
>> > news:9F8BBF73-5EE8-462C-AA76-2CD4FF3EE4C4@microsoft.com...
>> > > Hi I have my .mdb on a web server and in FrontPage I am trying to connect to
>> > > it so I can create my forms. First, is there anything I need to check on the
>> > > server itself as far as ODBC drivers, etc.. to allow Frontpage to connect?
>> > > Second I am following FrontPage's instructions to connect by - Database
>> > > Connections > Add a Catalog > Configure Database Connection > Server Name
>> > > (this is a bit confusing) because my server name is //srvwch16/d$, am I
>> > > missing something here? Then Username and Password and when I click next and
>> > > I get this huge error message stating that "an error occured while retrieving
>> > > a list of Databases. An authentication error occured, Your logon....."
>> > >
>> > > Any ideas, I really need to get this working?
>> > >
>> > > Thanks, Chris A
>> >
>> >
>> >



Re: Please Help with Database Connection by Chris

Chris
Thu Oct 27 09:11:02 CDT 2005

Ok, I fianlly made the site open up, I am now looking at my local site on the
left and the Remote on the right. I got that far, but what about connecting
FrontPage to my database so I can start creating my forms and linking my
boxes to the table? Are there any certain server permissions I need, etc..?

CA

"Thomas A. Rowe" wrote:

> File Menu | Open web / site
>
> Do this first, whenever you need to work on your web content.
>
> --
> ==============================================
> 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.
> ==============================================
>
> "Chris" <Chris@discussions.microsoft.com> wrote in message
> news:CB310096-B59F-43D4-9C30-912F59946DA0@microsoft.com...
> > Thomas, I am not 100% familiar with how FP works so what do you mean by
> > "current open FP web"?
> >
> > CA
> >
> > "Thomas A. Rowe" wrote:
> >
> >> Just drag-n-drop the database into your current open FP 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.
> >> ==============================================
> >>
> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> >> news:1D407A8E-2E9A-4F30-AF25-46293D7101CA@microsoft.com...
> >> > So basically I would do a file > import, choose the .mdb, etc..?
> >> >
> >> > CA
> >> >
> >> > "Thomas A. Rowe" wrote:
> >> >
> >> >> Import the database into FP, create a connection name and let FP move it to the fpdb folder.
> >> >>
> >> >> --
> >> >> ==============================================
> >> >> 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.
> >> >> ==============================================
> >> >>
> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> >> >> news:9F8BBF73-5EE8-462C-AA76-2CD4FF3EE4C4@microsoft.com...
> >> >> > Hi I have my .mdb on a web server and in FrontPage I am trying to connect to
> >> >> > it so I can create my forms. First, is there anything I need to check on the
> >> >> > server itself as far as ODBC drivers, etc.. to allow Frontpage to connect?
> >> >> > Second I am following FrontPage's instructions to connect by - Database
> >> >> > Connections > Add a Catalog > Configure Database Connection > Server Name
> >> >> > (this is a bit confusing) because my server name is //srvwch16/d$, am I
> >> >> > missing something here? Then Username and Password and when I click next and
> >> >> > I get this huge error message stating that "an error occured while retrieving
> >> >> > a list of Databases. An authentication error occured, Your logon....."
> >> >> >
> >> >> > Any ideas, I really need to get this working?
> >> >> >
> >> >> > Thanks, Chris A
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Re: Please Help with Database Connection by Thomas

Thomas
Thu Oct 27 10:17:32 CDT 2005

Once you have the database imported, then you create your form, then under form properties you
select to connect to the database using the connection you created when you imported the database.

--
==============================================
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.
==============================================

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:77514A6C-1B75-4E5C-858A-732932E77075@microsoft.com...
> Ok, I fianlly made the site open up, I am now looking at my local site on the
> left and the Remote on the right. I got that far, but what about connecting
> FrontPage to my database so I can start creating my forms and linking my
> boxes to the table? Are there any certain server permissions I need, etc..?
>
> CA
>
> "Thomas A. Rowe" wrote:
>
>> File Menu | Open web / site
>>
>> Do this first, whenever you need to work on your web content.
>>
>> --
>> ==============================================
>> 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.
>> ==============================================
>>
>> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> news:CB310096-B59F-43D4-9C30-912F59946DA0@microsoft.com...
>> > Thomas, I am not 100% familiar with how FP works so what do you mean by
>> > "current open FP web"?
>> >
>> > CA
>> >
>> > "Thomas A. Rowe" wrote:
>> >
>> >> Just drag-n-drop the database into your current open FP 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.
>> >> ==============================================
>> >>
>> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> >> news:1D407A8E-2E9A-4F30-AF25-46293D7101CA@microsoft.com...
>> >> > So basically I would do a file > import, choose the .mdb, etc..?
>> >> >
>> >> > CA
>> >> >
>> >> > "Thomas A. Rowe" wrote:
>> >> >
>> >> >> Import the database into FP, create a connection name and let FP move it to the fpdb
>> >> >> folder.
>> >> >>
>> >> >> --
>> >> >> ==============================================
>> >> >> 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.
>> >> >> ==============================================
>> >> >>
>> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> >> >> news:9F8BBF73-5EE8-462C-AA76-2CD4FF3EE4C4@microsoft.com...
>> >> >> > Hi I have my .mdb on a web server and in FrontPage I am trying to connect to
>> >> >> > it so I can create my forms. First, is there anything I need to check on the
>> >> >> > server itself as far as ODBC drivers, etc.. to allow Frontpage to connect?
>> >> >> > Second I am following FrontPage's instructions to connect by - Database
>> >> >> > Connections > Add a Catalog > Configure Database Connection > Server Name
>> >> >> > (this is a bit confusing) because my server name is //srvwch16/d$, am I
>> >> >> > missing something here? Then Username and Password and when I click next and
>> >> >> > I get this huge error message stating that "an error occured while retrieving
>> >> >> > a list of Databases. An authentication error occured, Your logon....."
>> >> >> >
>> >> >> > Any ideas, I really need to get this working?
>> >> >> >
>> >> >> > Thanks, Chris A
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>



Re: Please Help with Database Connection by Chris

Chris
Thu Oct 27 10:40:36 CDT 2005

I'm starting to give up.

When I open up Access, there is no import option available, where would I
find this? And then what do you mean by "Form" properties?

CA

"Thomas A. Rowe" wrote:

> Once you have the database imported, then you create your form, then under form properties you
> select to connect to the database using the connection you created when you imported the database.
>
> --
> ==============================================
> 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.
> ==============================================
>
> "Chris" <Chris@discussions.microsoft.com> wrote in message
> news:77514A6C-1B75-4E5C-858A-732932E77075@microsoft.com...
> > Ok, I fianlly made the site open up, I am now looking at my local site on the
> > left and the Remote on the right. I got that far, but what about connecting
> > FrontPage to my database so I can start creating my forms and linking my
> > boxes to the table? Are there any certain server permissions I need, etc..?
> >
> > CA
> >
> > "Thomas A. Rowe" wrote:
> >
> >> File Menu | Open web / site
> >>
> >> Do this first, whenever you need to work on your web content.
> >>
> >> --
> >> ==============================================
> >> 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.
> >> ==============================================
> >>
> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> >> news:CB310096-B59F-43D4-9C30-912F59946DA0@microsoft.com...
> >> > Thomas, I am not 100% familiar with how FP works so what do you mean by
> >> > "current open FP web"?
> >> >
> >> > CA
> >> >
> >> > "Thomas A. Rowe" wrote:
> >> >
> >> >> Just drag-n-drop the database into your current open FP 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.
> >> >> ==============================================
> >> >>
> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> >> >> news:1D407A8E-2E9A-4F30-AF25-46293D7101CA@microsoft.com...
> >> >> > So basically I would do a file > import, choose the .mdb, etc..?
> >> >> >
> >> >> > CA
> >> >> >
> >> >> > "Thomas A. Rowe" wrote:
> >> >> >
> >> >> >> Import the database into FP, create a connection name and let FP move it to the fpdb
> >> >> >> folder.
> >> >> >>
> >> >> >> --
> >> >> >> ==============================================
> >> >> >> 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.
> >> >> >> ==============================================
> >> >> >>
> >> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> >> >> >> news:9F8BBF73-5EE8-462C-AA76-2CD4FF3EE4C4@microsoft.com...
> >> >> >> > Hi I have my .mdb on a web server and in FrontPage I am trying to connect to
> >> >> >> > it so I can create my forms. First, is there anything I need to check on the
> >> >> >> > server itself as far as ODBC drivers, etc.. to allow Frontpage to connect?
> >> >> >> > Second I am following FrontPage's instructions to connect by - Database
> >> >> >> > Connections > Add a Catalog > Configure Database Connection > Server Name
> >> >> >> > (this is a bit confusing) because my server name is //srvwch16/d$, am I
> >> >> >> > missing something here? Then Username and Password and when I click next and
> >> >> >> > I get this huge error message stating that "an error occured while retrieving
> >> >> >> > a list of Databases. An authentication error occured, Your logon....."
> >> >> >> >
> >> >> >> > Any ideas, I really need to get this working?
> >> >> >> >
> >> >> >> > Thanks, Chris A
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Re: Please Help with Database Connection by Thomas

Thomas
Thu Oct 27 10:48:03 CDT 2005

Not Access, FP. On the web, you do not use Access, just the database.

You have to create the form in FP, and then connect it to your database

--
==============================================
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.
==============================================

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:A5CA496C-C3F0-460D-8C37-5C55A2E86510@microsoft.com...
> I'm starting to give up.
>
> When I open up Access, there is no import option available, where would I
> find this? And then what do you mean by "Form" properties?
>
> CA
>
> "Thomas A. Rowe" wrote:
>
>> Once you have the database imported, then you create your form, then under form properties you
>> select to connect to the database using the connection you created when you imported the
>> database.
>>
>> --
>> ==============================================
>> 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.
>> ==============================================
>>
>> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> news:77514A6C-1B75-4E5C-858A-732932E77075@microsoft.com...
>> > Ok, I fianlly made the site open up, I am now looking at my local site on the
>> > left and the Remote on the right. I got that far, but what about connecting
>> > FrontPage to my database so I can start creating my forms and linking my
>> > boxes to the table? Are there any certain server permissions I need, etc..?
>> >
>> > CA
>> >
>> > "Thomas A. Rowe" wrote:
>> >
>> >> File Menu | Open web / site
>> >>
>> >> Do this first, whenever you need to work on your web content.
>> >>
>> >> --
>> >> ==============================================
>> >> 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.
>> >> ==============================================
>> >>
>> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> >> news:CB310096-B59F-43D4-9C30-912F59946DA0@microsoft.com...
>> >> > Thomas, I am not 100% familiar with how FP works so what do you mean by
>> >> > "current open FP web"?
>> >> >
>> >> > CA
>> >> >
>> >> > "Thomas A. Rowe" wrote:
>> >> >
>> >> >> Just drag-n-drop the database into your current open FP 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.
>> >> >> ==============================================
>> >> >>
>> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> >> >> news:1D407A8E-2E9A-4F30-AF25-46293D7101CA@microsoft.com...
>> >> >> > So basically I would do a file > import, choose the .mdb, etc..?
>> >> >> >
>> >> >> > CA
>> >> >> >
>> >> >> > "Thomas A. Rowe" wrote:
>> >> >> >
>> >> >> >> Import the database into FP, create a connection name and let FP move it to the fpdb
>> >> >> >> folder.
>> >> >> >>
>> >> >> >> --
>> >> >> >> ==============================================
>> >> >> >> 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.
>> >> >> >> ==============================================
>> >> >> >>
>> >> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
>> >> >> >> news:9F8BBF73-5EE8-462C-AA76-2CD4FF3EE4C4@microsoft.com...
>> >> >> >> > Hi I have my .mdb on a web server and in FrontPage I am trying to connect to
>> >> >> >> > it so I can create my forms. First, is there anything I need to check on the
>> >> >> >> > server itself as far as ODBC drivers, etc.. to allow Frontpage to connect?
>> >> >> >> > Second I am following FrontPage's instructions to connect by - Database
>> >> >> >> > Connections > Add a Catalog > Configure Database Connection > Server Name
>> >> >> >> > (this is a bit confusing) because my server name is //srvwch16/d$, am I
>> >> >> >> > missing something here? Then Username and Password and when I click next and
>> >> >> >> > I get this huge error message stating that "an error occured while retrieving
>> >> >> >> > a list of Databases. An authentication error occured, Your logon....."
>> >> >> >> >
>> >> >> >> > Any ideas, I really need to get this working?
>> >> >> >> >
>> >> >> >> > Thanks, Chris A
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>