Ms Access upload to SQL Server 2005 BE & Sharepoint FE

[Anns via SQLMonster.com]

I have about 20 Ms Access Databases to need to be upload onto a SQL Server
2005.

Currently the are on a network/server residing on a specific drive. The goal
is to keep the user face the same (ms access) and put all of the tables onto
a SQL Server 2005 BE, and yet make those databases accessible to open/view
through Ms Sharepoint.

What is the simple (properties) way to grab all of those db's = 20 and upload
to server?
With out having to write code.
Pull all db's over to SQL then store the Ms Access databases on Sharepoint
where the user face remains the same and the tables are on the server and the
db's are accessible now through the company Intranet.

--
Message posted via http://www.sqlmonster.com

[Anns via SQLMonster.com]

Re: Ms Access upload to SQL Server 2005 BE & Sharepoint FE

The goal:

Take all current production Access Databases and/or any new development be
converted or newly developed in the .NET environment.
This means that we will store all data tables on SQL Server and develop all
front-end user interfaces in VB.NET or C# as browser based web applications.

So I use the DTS or IS (2005) to export/import all the tables from each ms
access db we have into the SQL Server 2005, but I want to keep the same user
faces that were originally created with those ms access db using the native
jet engines.

Using the VB.NET or C# as browswer based web applications, how can I upload
the already existing FE to Sharepoint (Web Base) and keep the FE the same and
of course the BE tables will now reside on SQL?






Anns wrote:[color=blue]
>I have about 20 Ms Access Databases to need to be upload onto a SQL Server
>2005.
>
>Currently the are on a network/server residing on a specific drive. The goal
>is to keep the user face the same (ms access) and put all of the tables onto
>a SQL Server 2005 BE, and yet make those databases accessible to open/view
>through Ms Sharepoint.
>
>What is the simple (properties) way to grab all of those db's = 20 and upload
>to server?
>With out having to write code.
>Pull all db's over to SQL then store the Ms Access databases on Sharepoint
>where the user face remains the same and the tables are on the server and the
>db's are accessible now through the company Intranet.[/color]

--
Message posted via SQLMonster.com

http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200606/1

[Anns via SQLMonster.com]

Re: Ms Access upload to SQL Server 2005 BE & Sharepoint FE

Referencing my statement: Using the VB.NET or C# as browswer based web
applications

What I meant to ask is, is there way to achieve the below with out having to
know or write in the above languages? Is there a property setting or tool
that can upload the existing FE to Sharepoint with out having to create in
the above languages?

Anns wrote:[color=blue]
>The goal:
>
>Take all current production Access Databases and/or any new development be
>converted or newly developed in the .NET environment.
>This means that we will store all data tables on SQL Server and develop all
>front-end user interfaces in VB.NET or C# as browser based web applications.
>
>So I use the DTS or IS (2005) to export/import all the tables from each ms
>access db we have into the SQL Server 2005, but I want to keep the same user
>faces that were originally created with those ms access db using the native
>jet engines.
>
>Using the VB.NET or C# as browswer based web applications, how can I upload
>the already existing FE to Sharepoint (Web Base) and keep the FE the same and
>of course the BE tables will now reside on SQL?
>
>
>[color=green]
>>I have about 20 Ms Access Databases to need to be upload onto a SQL Server
>>2005.[/color]
>[quoted text clipped - 10 lines][color=green]
>>where the user face remains the same and the tables are on the server and the
>>db's are accessible now through the company Intranet.[/color][/color]

--
Message posted via http://www.sqlmonster.com