469,148 Members | 1,316 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,148 developers. It's quick & easy.

Ms Access upload to SQL Server 2005 BE & Sharepoint FE

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
Jun 20 '06 #1
2 2977
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...neral/200606/1
Jun 21 '06 #2
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:
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?
I have about 20 Ms Access Databases to need to be upload onto a SQL Server
2005.

[quoted text clipped - 10 lines]
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
Jun 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by David W. Fenton | last post: by
52 posts views Thread by Neil | last post: by
1 post views Thread by Bob Alston | last post: by
2 posts views Thread by =?Utf-8?B?QWxhc3RhaXIgQmVsbA==?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.