473,379 Members | 1,235 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

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 3150
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: David W. Fenton | last post by:
I just read the latest post on the Access 12 Blog: Tracking Application Overview http://blogs.msdn.com/access/archive/2006/02/06/525888.aspx and just have to say: <Jon Stewart> Whuh?????...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
0
by: cherry | last post by:
Dear All, I have written a program in sharepoint, in which will call a Web Service of another Sharepoint portal server so that documents from sharepoint portal server A can push document to...
1
by: Bob Alston | last post by:
Anyone know of any features of the new Access 2007 that will improve on the ability of Access to work in a web environment??? Bob
5
by: Anns via AccessMonster.com | last post by:
My establishment has about 20 ms access db's that will be converted over (see subject). When we pull all the BE's over to SQL and the FE's on Sharepoint (.net) surely we don't have to change...
4
by: Anns via SQLMonster.com | last post by:
My company currently has about 20-25 Ms Access Database that they want to replace the FE with .net and the BE on SQL. This will be done using Visual Studio 2005. Once the FE is converted to...
2
by: =?Utf-8?B?QWxhc3RhaXIgQmVsbA==?= | last post by:
I am having trouble creating a web site on a server running sharepoint services. I am creating an ASP.Net website using Visual Studio 2005. The server I am trying to create it on is a Windows 2003...
13
by: Dave | last post by:
I work at a small private company that has been using VB 6.0 as a front end for Access databases for 8 years. It looks as though we will be migrating to Vista in the not-too-distant future. My...
4
by: dponce | last post by:
Can anyone share so insights as to anyone having successfully been able to upload an access database into SharePoint where the end users can alter, edit, deleted and save the information on the back...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.