Frontpage/Access/Sharepoint

[Stumorc]

Is it possible to connect to an Access Database using Frontpage 2003 on a web
site that is on a Sharepoint server? If so, please explain how.

Thanks in advance.

 

[Stefan B Rusynko]

File Import the Access DB into the FP web site & FP should create a DB connection

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Is it possible to connect to an Access Database using Frontpage 2003 on a web
| site that is on a Sharepoint server? If so, please explain how.
|
| Thanks in advance.

 

[Stumorc]

Ok, I got that part to work...the next problem is when I create a form and go
to the properties of that form to "send results to database"....the "send
results to database" option is greyed out.

 

[Thomas A. Rowe]

Make sure you have a web / site open in FP and that you have FP configured to use ASP / VBScript and
that the server is IIS and not Apache.

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

Ok, I got that part to work...the next problem is when I create a form and go
to the properties of that form to "send results to database"....the "send
results to database" option is greyed out.

File Import the Access DB into the FP web site & FP should create a DB connection

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Is it possible to connect to an Access Database using Frontpage 2003 on a web
| site that is on a Sharepoint server? If so, please explain how.
|
| Thanks in advance.

 

[Stumorc]

It is IIS and ASP/VBScript are enabled. I created a temporary site on a web
server that does not have Sharepoint Services, and I was able to create a
database connection and to use the database results function with no problem
at all. Is there something that I have to do differently since I'm using
Sharepoint Services?

Make sure you have a web / site open in FP and that you have FP configured to use ASP / VBScript and
that the server is IIS and not Apache.

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

Ok, I got that part to work...the next problem is when I create a form and go
to the properties of that form to "send results to database"....the "send
results to database" option is greyed out.

File Import the Access DB into the FP web site & FP should create a DB connection

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Is it possible to connect to an Access Database using Frontpage 2003 on a web
| site that is on a Sharepoint server? If so, please explain how.
|
| Thanks in advance.

 

[Jim Buyens]

Yes, in that case you should either:

o Create a Windows Sharepoint Services list, and use the update form that
WSS creates automatically, or

o Write a custom WSS "Web Part" in Visual Studio.NET.

o Run the app on a virtual server not running WSS.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming

It is IIS and ASP/VBScript are enabled. I created a temporary site on a web
server that does not have Sharepoint Services, and I was able to create a
database connection and to use the database results function with no problem
at all. Is there something that I have to do differently since I'm using
Sharepoint Services?

Make sure you have a web / site open in FP and that you have FP configured to use ASP / VBScript and
that the server is IIS and not Apache.

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

Ok, I got that part to work...the next problem is when I create a form and go
to the properties of that form to "send results to database"....the "send
results to database" option is greyed out.

:

File Import the Access DB into the FP web site & FP should create a DB connection

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Is it possible to connect to an Access Database using Frontpage 2003 on a web
| site that is on a Sharepoint server? If so, please explain how.
|
| Thanks in advance.