PC Review


Reply
Thread Tools Rate Thread

Access Database Link

 
 
=?Utf-8?B?S2FyZW4=?=
Guest
Posts: n/a
 
      30th Sep 2005
Hi,

I would like to create a hyperlink to open an Access database on our "home"
page. When the user clicks the hyperlink, it will open the database to the
Main Menu of the database. The database is located on the server in a folder
located with other Front Page docs. I am not sure where to start.
 
Reply With Quote
 
 
 
 
Clark
Guest
Posts: n/a
 
      2nd Oct 2005
Karen, I'm not sure what you mean by opening to the "main menu of the database".

But if what you want is hyperlinks to pages that show data from the database,
then make the "menu" on your home page using Frontpage and then assign each menu
item a hyperlink to a corresponding page on your website where you have used the
Database Results Wizard to produce the data expected from that menu item.

On Fri, 30 Sep 2005 08:41:04 -0700, "Karen" <(E-Mail Removed)>
wrote:

>Hi,
>
>I would like to create a hyperlink to open an Access database on our "home"
>page. When the user clicks the hyperlink, it will open the database to the
>Main Menu of the database. The database is located on the server in a folder
>located with other Front Page docs. I am not sure where to start.


 
Reply With Quote
 
=?Utf-8?B?S2FyZW4=?=
Guest
Posts: n/a
 
      3rd Oct 2005
We use Front Page for our intranet website. I want the user to be able to
click on a link and have that link open the Access database. The main menu
(switchboard) of the database already has links to certain reports that the
user can choose to run.

"Clark" wrote:

> Karen, I'm not sure what you mean by opening to the "main menu of the database".
>
> But if what you want is hyperlinks to pages that show data from the database,
> then make the "menu" on your home page using Frontpage and then assign each menu
> item a hyperlink to a corresponding page on your website where you have used the
> Database Results Wizard to produce the data expected from that menu item.
>
> On Fri, 30 Sep 2005 08:41:04 -0700, "Karen" <(E-Mail Removed)>
> wrote:
>
> >Hi,
> >
> >I would like to create a hyperlink to open an Access database on our "home"
> >page. When the user clicks the hyperlink, it will open the database to the
> >Main Menu of the database. The database is located on the server in a folder
> >located with other Front Page docs. I am not sure where to start.

>
>

 
Reply With Quote
 
Kathleen Anderson [MVP - FrontPage]
Guest
Posts: n/a
 
      3rd Oct 2005
If you know the network path to the switchboard, create a link to it from
your intranet web page.

--

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




"Karen" <(E-Mail Removed)> wrote in message
news:8D078F5A-1707-4649-9DF4-(E-Mail Removed)...
> We use Front Page for our intranet website. I want the user to be able to
> click on a link and have that link open the Access database. The main
> menu
> (switchboard) of the database already has links to certain reports that
> the
> user can choose to run.
>
> "Clark" wrote:
>
>> Karen, I'm not sure what you mean by opening to the "main menu of the
>> database".
>>
>> But if what you want is hyperlinks to pages that show data from the
>> database,
>> then make the "menu" on your home page using Frontpage and then assign
>> each menu
>> item a hyperlink to a corresponding page on your website where you have
>> used the
>> Database Results Wizard to produce the data expected from that menu item.
>>
>> On Fri, 30 Sep 2005 08:41:04 -0700, "Karen"
>> <(E-Mail Removed)>
>> wrote:
>>
>> >Hi,
>> >
>> >I would like to create a hyperlink to open an Access database on our
>> >"home"
>> >page. When the user clicks the hyperlink, it will open the database to
>> >the
>> >Main Menu of the database. The database is located on the server in a
>> >folder
>> >located with other Front Page docs. I am not sure where to start.

>>
>>



 
Reply With Quote
 
=?Utf-8?B?S2FyZW4=?=
Guest
Posts: n/a
 
      3rd Oct 2005
Thanks, we created the link, but the database does not open for everyone.
After clicking on File Download - Open, the screen flashes, almost like it
opened and closed right way, but does not open the database. It will let
you save at the File Download menu. On my computer, it opens with the
following message "Access to the specified device, path or file is denied."
When I click ok, the database is open and at the main menu.

"Kathleen Anderson [MVP - FrontPage]" wrote:

> If you know the network path to the switchboard, create a link to it from
> your intranet web page.
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
>
>
> "Karen" <(E-Mail Removed)> wrote in message
> news:8D078F5A-1707-4649-9DF4-(E-Mail Removed)...
> > We use Front Page for our intranet website. I want the user to be able to
> > click on a link and have that link open the Access database. The main
> > menu
> > (switchboard) of the database already has links to certain reports that
> > the
> > user can choose to run.
> >
> > "Clark" wrote:
> >
> >> Karen, I'm not sure what you mean by opening to the "main menu of the
> >> database".
> >>
> >> But if what you want is hyperlinks to pages that show data from the
> >> database,
> >> then make the "menu" on your home page using Frontpage and then assign
> >> each menu
> >> item a hyperlink to a corresponding page on your website where you have
> >> used the
> >> Database Results Wizard to produce the data expected from that menu item.
> >>
> >> On Fri, 30 Sep 2005 08:41:04 -0700, "Karen"
> >> <(E-Mail Removed)>
> >> wrote:
> >>
> >> >Hi,
> >> >
> >> >I would like to create a hyperlink to open an Access database on our
> >> >"home"
> >> >page. When the user clicks the hyperlink, it will open the database to
> >> >the
> >> >Main Menu of the database. The database is located on the server in a
> >> >folder
> >> >located with other Front Page docs. I am not sure where to start.
> >>
> >>

>
>
>

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      3rd Oct 2005
You really can't have users access the database directly via a web page. On the web you need to use
ASP/ASP.net , etc. to access 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.
==============================================

"Karen" <(E-Mail Removed)> wrote in message
news:8D078F5A-1707-4649-9DF4-(E-Mail Removed)...
> We use Front Page for our intranet website. I want the user to be able to
> click on a link and have that link open the Access database. The main menu
> (switchboard) of the database already has links to certain reports that the
> user can choose to run.
>
> "Clark" wrote:
>
>> Karen, I'm not sure what you mean by opening to the "main menu of the database".
>>
>> But if what you want is hyperlinks to pages that show data from the database,
>> then make the "menu" on your home page using Frontpage and then assign each menu
>> item a hyperlink to a corresponding page on your website where you have used the
>> Database Results Wizard to produce the data expected from that menu item.
>>
>> On Fri, 30 Sep 2005 08:41:04 -0700, "Karen" <(E-Mail Removed)>
>> wrote:
>>
>> >Hi,
>> >
>> >I would like to create a hyperlink to open an Access database on our "home"
>> >page. When the user clicks the hyperlink, it will open the database to the
>> >Main Menu of the database. The database is located on the server in a folder
>> >located with other Front Page docs. I am not sure where to start.

>>
>>



 
Reply With Quote
 
Kathleen Anderson [MVP - FrontPage]
Guest
Posts: n/a
 
      3rd Oct 2005
But wouldn't a link to the switchboard work? They're not opening the
database.

--

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




"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> You really can't have users access the database directly via a web page.
> On the web you need to use ASP/ASP.net , etc. to access 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.
> ==============================================
>
> "Karen" <(E-Mail Removed)> wrote in message
> news:8D078F5A-1707-4649-9DF4-(E-Mail Removed)...
>> We use Front Page for our intranet website. I want the user to be able
>> to
>> click on a link and have that link open the Access database. The main
>> menu
>> (switchboard) of the database already has links to certain reports that
>> the
>> user can choose to run.
>>
>> "Clark" wrote:
>>
>>> Karen, I'm not sure what you mean by opening to the "main menu of the
>>> database".
>>>
>>> But if what you want is hyperlinks to pages that show data from the
>>> database,
>>> then make the "menu" on your home page using Frontpage and then assign
>>> each menu
>>> item a hyperlink to a corresponding page on your website where you have
>>> used the
>>> Database Results Wizard to produce the data expected from that menu
>>> item.
>>>
>>> On Fri, 30 Sep 2005 08:41:04 -0700, "Karen"
>>> <(E-Mail Removed)>
>>> wrote:
>>>
>>> >Hi,
>>> >
>>> >I would like to create a hyperlink to open an Access database on our
>>> >"home"
>>> >page. When the user clicks the hyperlink, it will open the database to
>>> >the
>>> >Main Menu of the database. The database is located on the server in a
>>> >folder
>>> >located with other Front Page docs. I am not sure where to start.
>>>
>>>

>
>



 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      3rd Oct 2005
They are still opening 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.
==============================================

"Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> But wouldn't a link to the switchboard work? They're not opening the database.
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
>
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> You really can't have users access the database directly via a web page. On the web you need to
>> use ASP/ASP.net , etc. to access 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.
>> ==============================================
>>
>> "Karen" <(E-Mail Removed)> wrote in message
>> news:8D078F5A-1707-4649-9DF4-(E-Mail Removed)...
>>> We use Front Page for our intranet website. I want the user to be able to
>>> click on a link and have that link open the Access database. The main menu
>>> (switchboard) of the database already has links to certain reports that the
>>> user can choose to run.
>>>
>>> "Clark" wrote:
>>>
>>>> Karen, I'm not sure what you mean by opening to the "main menu of the database".
>>>>
>>>> But if what you want is hyperlinks to pages that show data from the database,
>>>> then make the "menu" on your home page using Frontpage and then assign each menu
>>>> item a hyperlink to a corresponding page on your website where you have used the
>>>> Database Results Wizard to produce the data expected from that menu item.
>>>>
>>>> On Fri, 30 Sep 2005 08:41:04 -0700, "Karen" <(E-Mail Removed)>
>>>> wrote:
>>>>
>>>> >Hi,
>>>> >
>>>> >I would like to create a hyperlink to open an Access database on our "home"
>>>> >page. When the user clicks the hyperlink, it will open the database to the
>>>> >Main Menu of the database. The database is located on the server in a folder
>>>> >located with other Front Page docs. I am not sure where to start.
>>>>
>>>>

>>
>>

>
>



 
Reply With Quote
 
=?Utf-8?B?S2FyZW4=?=
Guest
Posts: n/a
 
      6th Oct 2005
We have a SQL database on the same server that uses Cold Fusion language.
Could I still open the Access database using Cold Fusion on the Front Page
website?

"Thomas A. Rowe" wrote:

> They are still opening 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.
> ==============================================
>
> "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > But wouldn't a link to the switchboard work? They're not opening the database.
> >
> > --
> >
> > ~ Kathleen Anderson
> > Microsoft MVP - FrontPage
> > Spider Web Woman Designs
> > web: http://www.spiderwebwoman.com/resources/
> >
> >
> >
> >
> > "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> > news:%(E-Mail Removed)...
> >> You really can't have users access the database directly via a web page. On the web you need to
> >> use ASP/ASP.net , etc. to access 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.
> >> ==============================================
> >>
> >> "Karen" <(E-Mail Removed)> wrote in message
> >> news:8D078F5A-1707-4649-9DF4-(E-Mail Removed)...
> >>> We use Front Page for our intranet website. I want the user to be able to
> >>> click on a link and have that link open the Access database. The main menu
> >>> (switchboard) of the database already has links to certain reports that the
> >>> user can choose to run.
> >>>
> >>> "Clark" wrote:
> >>>
> >>>> Karen, I'm not sure what you mean by opening to the "main menu of the database".
> >>>>
> >>>> But if what you want is hyperlinks to pages that show data from the database,
> >>>> then make the "menu" on your home page using Frontpage and then assign each menu
> >>>> item a hyperlink to a corresponding page on your website where you have used the
> >>>> Database Results Wizard to produce the data expected from that menu item.
> >>>>
> >>>> On Fri, 30 Sep 2005 08:41:04 -0700, "Karen" <(E-Mail Removed)>
> >>>> wrote:
> >>>>
> >>>> >Hi,
> >>>> >
> >>>> >I would like to create a hyperlink to open an Access database on our "home"
> >>>> >page. When the user clicks the hyperlink, it will open the database to the
> >>>> >Main Menu of the database. The database is located on the server in a folder
> >>>> >located with other Front Page docs. I am not sure where to start.
> >>>>
> >>>>
> >>
> >>

> >
> >

>
>
>

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      6th Oct 2005
Yes, you can use CF.

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

"Karen" <(E-Mail Removed)> wrote in message
news:EAAF41DE-D8B5-46D6-834C-(E-Mail Removed)...
> We have a SQL database on the same server that uses Cold Fusion language.
> Could I still open the Access database using Cold Fusion on the Front Page
> website?
>
> "Thomas A. Rowe" wrote:
>
>> They are still opening 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.
>> ==============================================
>>
>> "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > But wouldn't a link to the switchboard work? They're not opening the database.
>> >
>> > --
>> >
>> > ~ Kathleen Anderson
>> > Microsoft MVP - FrontPage
>> > Spider Web Woman Designs
>> > web: http://www.spiderwebwoman.com/resources/
>> >
>> >
>> >
>> >
>> > "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>> > news:%(E-Mail Removed)...
>> >> You really can't have users access the database directly via a web page. On the web you need
>> >> to
>> >> use ASP/ASP.net , etc. to access 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.
>> >> ==============================================
>> >>
>> >> "Karen" <(E-Mail Removed)> wrote in message
>> >> news:8D078F5A-1707-4649-9DF4-(E-Mail Removed)...
>> >>> We use Front Page for our intranet website. I want the user to be able to
>> >>> click on a link and have that link open the Access database. The main menu
>> >>> (switchboard) of the database already has links to certain reports that the
>> >>> user can choose to run.
>> >>>
>> >>> "Clark" wrote:
>> >>>
>> >>>> Karen, I'm not sure what you mean by opening to the "main menu of the database".
>> >>>>
>> >>>> But if what you want is hyperlinks to pages that show data from the database,
>> >>>> then make the "menu" on your home page using Frontpage and then assign each menu
>> >>>> item a hyperlink to a corresponding page on your website where you have used the
>> >>>> Database Results Wizard to produce the data expected from that menu item.
>> >>>>
>> >>>> On Fri, 30 Sep 2005 08:41:04 -0700, "Karen" <(E-Mail Removed)>
>> >>>> wrote:
>> >>>>
>> >>>> >Hi,
>> >>>> >
>> >>>> >I would like to create a hyperlink to open an Access database on our "home"
>> >>>> >page. When the user clicks the hyperlink, it will open the database to the
>> >>>> >Main Menu of the database. The database is located on the server in a folder
>> >>>> >located with other Front Page docs. I am not sure where to start.
>> >>>>
>> >>>>
>> >>
>> >>
>> >
>> >

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
CAN YOU LINK ACCESS 2000 TABLES TO FORMS IN 2003 ACCESS DATABASE BJONES6581 Microsoft Access 1 11th Sep 2009 05:12 PM
Create a link between Access Database and Pervasive Database =?Utf-8?B?TGF2YXRyZXNz?= Microsoft Access VBA Modules 1 26th Oct 2006 09:34 PM
How to link an access database from an html link =?Utf-8?B?TG91aXNl?= Microsoft Access 0 7th Jul 2005 09:04 PM
link access database to a database on the internet =?Utf-8?B?RGVhbGVybG95YWx0eQ==?= Microsoft Access External Data 2 22nd Mar 2005 04:17 AM
MS Access ODBC link to another Access database outside of my netwo =?Utf-8?B?S2F0aWUgQg==?= Microsoft Access External Data 4 18th Jan 2005 12:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:18 PM.