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

Jun 20 '06 #1

Subscribe Reply

3164

Anns via SQLMonster.com

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

Anns via SQLMonster.com

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

Similar topics

1490

Access 12 Blog's Latest Post

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>

Microsoft Access / VBA

9957

Access 2002 vs. 2003

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...

Microsoft Access / VBA

1846

Upload File Program in Sharepoint and Timeout occur

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...

.NET Framework

463

Access 2007

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

Microsoft Access / VBA

3607

Help......replace Access with a .NET front end and SQL Backend solution

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:

Microsoft Access / VBA

4280

Replace Access with a .NET front end and SQL Backend solution.

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.

Microsoft SQL Server

4330

Problem creating ASP website on server running sharepoint services

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...

ASP / Active Server Pages

4917

RealBasic for an Access Front End?

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)...

Microsoft Access / VBA

6737

Uploading Access 2003 into SharePoint v2.0 ?

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...

Microsoft Access / VBA

8483

What is ONU?

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...

General

8927

Problem With Comparison Operator <=> in G++

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...

C / C++

7445

AI Job Threat for Devs

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...

Career Advice

6237

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5703

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4416

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2819

transfer the data from one system to another through ip address

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

C# / C Sharp

2062

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1816

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General