I have a website with a small database which I access with some custom .asp
code. A while back I tried accessing the database with the Database Results
Wizard which worked fine. I changed my mind and deleted the query and
associated files manually within FP 2003. Now I'd like to create a new
results query with the Database Results Wizard but the
"Insert>Database>Results" option is greyed out.

Any reason why it's greyed out and thoughts on what I can do to fix it?

Thanks.

Reimport the database back into your web so it will recreate the associated
files.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"Bob L" <(E-Mail Removed)> wrote in message
news:%23ASISMQ$(E-Mail Removed)...
>I have a website with a small database which I access with some custom .asp
>code. A while back I tried accessing the database with the Database
>Results Wizard which worked fine. I changed my mind and deleted the query
>and associated files manually within FP 2003. Now I'd like to create a new
>results query with the Database Results Wizard but the
>"Insert>Database>Results" option is greyed out.
>
> Any reason why it's greyed out and thoughts on what I can do to fix it?
>
> Thanks.
>

I deleted my database and re-imported it but the "results" option is still
greyed out.

"Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
message news:Ons4jPQ$(E-Mail Removed)...
> Reimport the database back into your web so it will recreate the
> associated files.
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
> "Bob L" <(E-Mail Removed)> wrote in message
> news:%23ASISMQ$(E-Mail Removed)...
>>I have a website with a small database which I access with some custom
>>.asp code. A while back I tried accessing the database with the Database
>>Results Wizard which worked fine. I changed my mind and deleted the query
>>and associated files manually within FP 2003. Now I'd like to create a
>>new results query with the Database Results Wizard but the
>>"Insert>Database>Results" option is greyed out.
>>
>> Any reason why it's greyed out and thoughts on what I can do to fix it?
>>
>> Thanks.
>>
>
>

Do you have a web open?

"Bob L" <(E-Mail Removed)> wrote in message
news:%23ASISMQ$(E-Mail Removed)...
>I have a website with a small database which I access with some custom .asp
>code. A while back I tried accessing the database with the Database
>Results Wizard which worked fine. I changed my mind and deleted the query
>and associated files manually within FP 2003. Now I'd like to create a new
>results query with the Database Results Wizard but the
>"Insert>Database>Results" option is greyed out.
>
> Any reason why it's greyed out and thoughts on what I can do to fix it?
>
> Thanks.
>

Yes. In FP2003 with the web I'm developing open, I've tried deleting
deleting the Access database and then re-importing it but the
"Insert>Database>Results" is still greyed out on the menu. I really need to
be able to use the Database Results Wizard.


"Andrew Murray" <(E-Mail Removed)> wrote in message
news:uBhXCfX$(E-Mail Removed)...
> Do you have a web open?
>
> "Bob L" <(E-Mail Removed)> wrote in message
> news:%23ASISMQ$(E-Mail Removed)...
>>I have a website with a small database which I access with some custom
>>.asp code. A while back I tried accessing the database with the Database
>>Results Wizard which worked fine. I changed my mind and deleted the query
>>and associated files manually within FP 2003. Now I'd like to create a
>>new results query with the Database Results Wizard but the
>>"Insert>Database>Results" option is greyed out.
>>
>> Any reason why it's greyed out and thoughts on what I can do to fix it?
>>
>> Thanks.
>>
>
>

When you reimported the database, did FrontPage (re)create the fpdb folder
and put the database there, (re)create the global.asa and prompt you to
specify a database connection name?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"Bob L" <(E-Mail Removed)> wrote in message
news:eODpkyZ$(E-Mail Removed)...
> Yes. In FP2003 with the web I'm developing open, I've tried deleting
> deleting the Access database and then re-importing it but the
> "Insert>Database>Results" is still greyed out on the menu. I really need
> to be able to use the Database Results Wizard.
>
>
> "Andrew Murray" <(E-Mail Removed)> wrote in message
> news:uBhXCfX$(E-Mail Removed)...
>> Do you have a web open?
>>
>> "Bob L" <(E-Mail Removed)> wrote in message
>> news:%23ASISMQ$(E-Mail Removed)...
>>>I have a website with a small database which I access with some custom
>>>.asp code. A while back I tried accessing the database with the Database
>>>Results Wizard which worked fine. I changed my mind and deleted the
>>>query and associated files manually within FP 2003. Now I'd like to
>>>create a new results query with the Database Results Wizard but the
>>>"Insert>Database>Results" option is greyed out.
>>>
>>> Any reason why it's greyed out and thoughts on what I can do to fix it?
>>>
>>> Thanks.
>>>
>>
>>
>
>

I'm using the db for logging on users to the website. The logon files are
located in the "logon" folder and I imported the db into the "_private"
folder under "logon". When I imported the db FP2003 assumed it would go in
the fpdb folder but I changed it to the _private folder. It also prompted
me to specify a database connection name which I declined.

The "Insert>Database>Results" menu item is greyed out in other webs as well
as the one I've imported the logon db into. Do you have to have a db
located somewhere in a website before this menu item is available?

"Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
message news:uJxqZ3Z$(E-Mail Removed)...
> When you reimported the database, did FrontPage (re)create the fpdb folder
> and put the database there, (re)create the global.asa and prompt you to
> specify a database connection name?
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
> "Bob L" <(E-Mail Removed)> wrote in message
> news:eODpkyZ$(E-Mail Removed)...
>> Yes. In FP2003 with the web I'm developing open, I've tried deleting
>> deleting the Access database and then re-importing it but the
>> "Insert>Database>Results" is still greyed out on the menu. I really need
>> to be able to use the Database Results Wizard.
>>
>>
>> "Andrew Murray" <(E-Mail Removed)> wrote in message
>> news:uBhXCfX$(E-Mail Removed)...
>>> Do you have a web open?
>>>
>>> "Bob L" <(E-Mail Removed)> wrote in message
>>> news:%23ASISMQ$(E-Mail Removed)...
>>>>I have a website with a small database which I access with some custom
>>>>.asp code. A while back I tried accessing the database with the
>>>>Database Results Wizard which worked fine. I changed my mind and
>>>>deleted the query and associated files manually within FP 2003. Now I'd
>>>>like to create a new results query with the Database Results Wizard but
>>>>the "Insert>Database>Results" option is greyed out.
>>>>
>>>> Any reason why it's greyed out and thoughts on what I can do to fix it?
>>>>
>>>> Thanks.
>>>>
>>>
>>>
>>
>>
>
>

I believe that in order to use the database results wizard, you must have a
database connection specified.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"Bob L" <(E-Mail Removed)> wrote in message
news:uuRW3Xb$(E-Mail Removed)...
> I'm using the db for logging on users to the website. The logon files are
> located in the "logon" folder and I imported the db into the "_private"
> folder under "logon". When I imported the db FP2003 assumed it would go
> in the fpdb folder but I changed it to the _private folder. It also
> prompted me to specify a database connection name which I declined.
>
> The "Insert>Database>Results" menu item is greyed out in other webs as
> well as the one I've imported the logon db into. Do you have to have a db
> located somewhere in a website before this menu item is available?
>
> "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
> message news:uJxqZ3Z$(E-Mail Removed)...
>> When you reimported the database, did FrontPage (re)create the fpdb
>> folder and put the database there, (re)create the global.asa and prompt
>> you to specify a database connection name?
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web: http://www.spiderwebwoman.com/resources/
>>
>>
>> "Bob L" <(E-Mail Removed)> wrote in message
>> news:eODpkyZ$(E-Mail Removed)...
>>> Yes. In FP2003 with the web I'm developing open, I've tried deleting
>>> deleting the Access database and then re-importing it but the
>>> "Insert>Database>Results" is still greyed out on the menu. I really
>>> need to be able to use the Database Results Wizard.
>>>
>>>
>>> "Andrew Murray" <(E-Mail Removed)> wrote in message
>>> news:uBhXCfX$(E-Mail Removed)...
>>>> Do you have a web open?
>>>>
>>>> "Bob L" <(E-Mail Removed)> wrote in message
>>>> news:%23ASISMQ$(E-Mail Removed)...
>>>>>I have a website with a small database which I access with some custom
>>>>>.asp code. A while back I tried accessing the database with the
>>>>>Database Results Wizard which worked fine. I changed my mind and
>>>>>deleted the query and associated files manually within FP 2003. Now
>>>>>I'd like to create a new results query with the Database Results Wizard
>>>>>but the "Insert>Database>Results" option is greyed out.
>>>>>
>>>>> Any reason why it's greyed out and thoughts on what I can do to fix
>>>>> it?
>>>>>
>>>>> Thanks.
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

You should let FP place the database in the fpdb folder which has specific permissions assigned by
FP to protect 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.
==============================================

"Bob L" <(E-Mail Removed)> wrote in message news:uuRW3Xb$(E-Mail Removed)...
> I'm using the db for logging on users to the website. The logon files are located in the "logon"
> folder and I imported the db into the "_private" folder under "logon". When I imported the db
> FP2003 assumed it would go in the fpdb folder but I changed it to the _private folder. It also
> prompted me to specify a database connection name which I declined.
>
> The "Insert>Database>Results" menu item is greyed out in other webs as well as the one I've
> imported the logon db into. Do you have to have a db located somewhere in a website before this
> menu item is available?
>
> "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in message
> news:uJxqZ3Z$(E-Mail Removed)...
>> When you reimported the database, did FrontPage (re)create the fpdb folder and put the database
>> there, (re)create the global.asa and prompt you to specify a database connection name?
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web: http://www.spiderwebwoman.com/resources/
>>
>>
>> "Bob L" <(E-Mail Removed)> wrote in message news:eODpkyZ$(E-Mail Removed)...
>>> Yes. In FP2003 with the web I'm developing open, I've tried deleting deleting the Access
>>> database and then re-importing it but the "Insert>Database>Results" is still greyed out on the
>>> menu. I really need to be able to use the Database Results Wizard.
>>>
>>>
>>> "Andrew Murray" <(E-Mail Removed)> wrote in message
>>> news:uBhXCfX$(E-Mail Removed)...
>>>> Do you have a web open?
>>>>
>>>> "Bob L" <(E-Mail Removed)> wrote in message news:%23ASISMQ$(E-Mail Removed)...
>>>>>I have a website with a small database which I access with some custom .asp code. A while back
>>>>>I tried accessing the database with the Database Results Wizard which worked fine. I changed
>>>>>my mind and deleted the query and associated files manually within FP 2003. Now I'd like to
>>>>>create a new results query with the Database Results Wizard but the "Insert>Database>Results"
>>>>>option is greyed out.
>>>>>
>>>>> Any reason why it's greyed out and thoughts on what I can do to fix it?
>>>>>
>>>>> Thanks.
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

I looked in the Site Properties for the logon subweb and found that there is
indeed a database connection specified with the logon.db. But the menu item
is still greyed out when I try to start up the results wizard in any page in
both the main web or the logon subweb. I also tried deleting the connection
and then re-establishing it but the option is still greyed out. I just
tried "Detect and Repair" but still no success.

Thanks a lot for tying to help. I really appreciate it.

"Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
message news:evT9qub$(E-Mail Removed)...
>I believe that in order to use the database results wizard, you must have a
>database connection specified.
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
> "Bob L" <(E-Mail Removed)> wrote in message
> news:uuRW3Xb$(E-Mail Removed)...
>> I'm using the db for logging on users to the website. The logon files
>> are located in the "logon" folder and I imported the db into the
>> "_private" folder under "logon". When I imported the db FP2003 assumed
>> it would go in the fpdb folder but I changed it to the _private folder.
>> It also prompted me to specify a database connection name which I
>> declined.
>>
>> The "Insert>Database>Results" menu item is greyed out in other webs as
>> well as the one I've imported the logon db into. Do you have to have a
>> db located somewhere in a website before this menu item is available?
>>
>> "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
>> message news:uJxqZ3Z$(E-Mail Removed)...
>>> When you reimported the database, did FrontPage (re)create the fpdb
>>> folder and put the database there, (re)create the global.asa and prompt
>>> you to specify a database connection name?
>>>
>>> --
>>> ~ Kathleen Anderson
>>> Microsoft MVP - FrontPage
>>> Spider Web Woman Designs
>>> web: http://www.spiderwebwoman.com/resources/
>>>
>>>
>>> "Bob L" <(E-Mail Removed)> wrote in message
>>> news:eODpkyZ$(E-Mail Removed)...
>>>> Yes. In FP2003 with the web I'm developing open, I've tried deleting
>>>> deleting the Access database and then re-importing it but the
>>>> "Insert>Database>Results" is still greyed out on the menu. I really
>>>> need to be able to use the Database Results Wizard.
>>>>
>>>>
>>>> "Andrew Murray" <(E-Mail Removed)> wrote in message
>>>> news:uBhXCfX$(E-Mail Removed)...
>>>>> Do you have a web open?
>>>>>
>>>>> "Bob L" <(E-Mail Removed)> wrote in message
>>>>> news:%23ASISMQ$(E-Mail Removed)...
>>>>>>I have a website with a small database which I access with some custom
>>>>>>.asp code. A while back I tried accessing the database with the
>>>>>>Database Results Wizard which worked fine. I changed my mind and
>>>>>>deleted the query and associated files manually within FP 2003. Now
>>>>>>I'd like to create a new results query with the Database Results
>>>>>>Wizard but the "Insert>Database>Results" option is greyed out.
>>>>>>
>>>>>> Any reason why it's greyed out and thoughts on what I can do to fix
>>>>>> it?
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>