Microsoft Sharepoint Portal Server :: Database Access integration w/MOSS 2007


	Database Access integration w/MOSS 2007 Hello, I am looking to integrate all of my users services with MOSS. We currently use access 2003 as an interface to input data into a sql 2000 sp4 backend. Is there any way to integrate access with sharepoint where my users can access the database interface through the sharepoint intranet? MOSS 2007 allows SharePoint Lists to be synchronized as/with Access 2007 tables and probably the reverse applies but with several restrictions over the kind of Access Tables (and field types within them) There's no similar functionality to my knowledge for Access 2003. However if all you are using Access for is to be a front-end to SQL Server why not do this [connection to SQL Server] direct from MOSS ? Mike Walsh WSS FAQ http://www.wssfaq.com No private e-mail please. "Cy" <C@discussions.microsoft.com> wrote in message news:795FB0A2-856F-4118-BC2F-6547F6789897@microsoft.com... - Hide quoted text - > Hello, > I am looking to integrate all of my users services with MOSS. We currently > use access 2003 as an interface to input data into a sql 2000 sp4 backend. > Is there any way to integrate access with sharepoint where my users can > access the database interface through the sharepoint intranet? Do you know of any easy to follow documentation to coonect to SQL directly from MOSS? - Hide quoted text - "Mike Walsh" wrote: > MOSS 2007 allows SharePoint Lists to be synchronized as/with Access 2007 > tables and probably the reverse applies but with several restrictions over > the kind of Access Tables (and field types within them) > There's no similar functionality to my knowledge for Access 2003. > However if all you are using Access for is to be a front-end to SQL Server > why not do this [connection to SQL Server] direct from MOSS ? > Mike Walsh > WSS FAQ http://www.wssfaq.com > No private e-mail please. > "Cy" <C@discussions.microsoft.com> wrote in message > news:795FB0A2-856F-4118-BC2F-6547F6789897@microsoft.com... > > Hello, > > I am looking to integrate all of my users services with MOSS. We currently > > use access 2003 as an interface to input data into a sql 2000 sp4 backend. > > Is there any way to integrate access with sharepoint where my users can > > access the database interface through the sharepoint intranet? Documentation, no. But one way is to use the SPD 2007 Data function to create a Data View Web Part. Mike Walsh "Cy" <C@discussions.microsoft.com> wrote in message news:0ABFA3C7-C6E3-48FC-9A0E-E37F8FA68E32@microsoft.com... - Hide quoted text - > Do you know of any easy to follow documentation to coonect to SQL directly > from MOSS? > "Mike Walsh" wrote: >> MOSS 2007 allows SharePoint Lists to be synchronized as/with Access >> 2007 >> tables and probably the reverse applies but with several restrictions >> over >> the kind of Access Tables (and field types within them) >> There's no similar functionality to my knowledge for Access 2003. >> However if all you are using Access for is to be a front-end to SQL >> Server >> why not do this [connection to SQL Server] direct from MOSS ? >> Mike Walsh >> WSS FAQ http://www.wssfaq.com >> No private e-mail please. >> "Cy" <C@discussions.microsoft.com> wrote in message >> news:795FB0A2-856F-4118-BC2F-6547F6789897@microsoft.com... >> > Hello, >> > I am looking to integrate all of my users services with MOSS. We >> > currently >> > use access 2003 as an interface to input data into a sql 2000 sp4 >> > backend. >> > Is there any way to integrate access with sharepoint where my users can >> > access the database interface through the sharepoint intranet?