|
|
Posted by Anns via SQLMonster.com on 06/21/06 15:45
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:
>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 SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200606/1
Navigation:
[Reply to this message]
|