Access database record editing

[Wayne Jacem]

Hi, Help Please:
I wish to integrate an Access 2003 database into my FrontPage 2003 website.
The hosting server has Frontpage Extensions enabled but is not Sharepoint
enabled.
Using a Form I am able to add records online and with a Results page I can
view the records returned from a query.

However I can't use a Data View as Frontpage says that it is only available
to hosting servers with Sharepoint. Webpart and Column View are greyed out.
Creating a Data access Page with Access creates an online form upto the point
where it needs to access the Access Database onthe website. The message is
"Data Provider could not be initialized" followed by a message "Not a valid
file name". I have tried many different unc style references for pointing to
the database with no luck.

Am I trying to do something a little too tricky for standard Frontpage?

 

[Stefan B Rusynko]

Dataview and Webparts are only applicable on WSS (Windows SharePoint Services), not the FP SE
Under the FP SE you are limited to the DBRW (Insert Database Results) and DBIW (File New Site)




| Hi, Help Please:
| I wish to integrate an Access 2003 database into my FrontPage 2003 website.
| The hosting server has Frontpage Extensions enabled but is not Sharepoint
| enabled.
| Using a Form I am able to add records online and with a Results page I can
| view the records returned from a query.
|
| However I can't use a Data View as Frontpage says that it is only available
| to hosting servers with Sharepoint. Webpart and Column View are greyed out.
| Creating a Data access Page with Access creates an online form upto the point
| where it needs to access the Access Database onthe website. The message is
| "Data Provider could not be initialized" followed by a message "Not a valid
| file name". I have tried many different unc style references for pointing to
| the database with no luck.
|
| Am I trying to do something a little too tricky for standard Frontpage?