473,834 Members | 1,854 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3182
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
1495
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????? </Jon Stewart>
52
10013
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 2005, and, since he already has licenses for Office Pro 2002, he wants to upgrade to that. I've been saying that we need to upgrade to Access 2003, not 2002, even if Office is kept at 2002. We are also looking to do a fair amount of...
0
1853
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 Sharepoint portal Server B whose domain is stood alone. However, the program is unable to upload file over 2MB, when the file size exceeds, timeout will occur! I have tried to make a change in the web.config and machine.config of sharepoint portal...
1
463
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
3622
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 every user face, we should be able to use the same FE in as before as now on Sharepoint? ANSWER:
4
4287
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 .net and the BE is SQL they all will be accessed through our intranet (sharepoint). I work in Ms Access and intermediate at VBA and just learing SQL through the ENTERPRISE MANAGER SCREEN.
2
4339
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 server. From what I understand I need to exclude in sharepoint services the folder where the application will be deployed. I have done this in the Define Managed Paths section of the Sharepoint management site, but it has no effect. Even after...
13
4938
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 hope is to move to RealBasic at that point. Does anyone know about RB connecting to Access tables via ADO? I was reading some archived RB posts and someone wrote that RB doesn't connect to Access. That was from a 2004 post. Is that (still)...
4
6750
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 end so that everyone else could see the changes made by others? The current SharePoint v2.0 allows me to upload a document and when I do it this way it will successfully take the whole database and even open it up in access but the problem we are...
0
9799
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10793
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10510
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10548
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9331
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6954
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5794
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4427
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3081
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.