473,836 Members | 1,505 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Convert an Access database to SQL

Hi,
I have an Access database and am having an ASP.NEt application written for
it. It is almost complete. I have a hosting company that I signed up with
a month ago but before I did anything I asked them if Access and ASP.NET
would work on their servers, they said yes so I bought in. Now they are
saying my application wont work on their servers using MSaccess and I can
only use SQL or asp 3.0. They are saying Microsoft is trying to keep Ms
Access as a desktop application. The database is done, and the app is
almost done. I have paid alot of money for this application. What are my
options here?

How hard is it to convert an Access Database to SQL? What ramifications
does this have on the ASP.NET part?

How hard is it to convert to asp 3.0?

I was also told XML would work. DOnt know anything about it.

What about other hosts?

Any other options?

I just cant believe this.
Any help and insight would be greatly appreciated.

Cory

Nov 12 '05 #1
25 4398
Please see the recent thread underway on this subject here at
comp.databases. ms-access.

On Wed, 07 Jan 2004 04:56:55 GMT, "cory" <no***@here.com > wrote:
Hi,
I have an Access database and am having an ASP.NEt application written for
it. It is almost complete. I have a hosting company that I signed up with
a month ago but before I did anything I asked them if Access and ASP.NET
would work on their servers, they said yes so I bought in. Now they are
saying my application wont work on their servers using MSaccess and I can
only use SQL or asp 3.0. They are saying Microsoft is trying to keep Ms
Access as a desktop application. The database is done, and the app is
almost done. I have paid alot of money for this application. What are my
options here?

How hard is it to convert an Access Database to SQL? What ramifications
does this have on the ASP.NET part?

How hard is it to convert to asp 3.0?

I was also told XML would work. DOnt know anything about it.

What about other hosts?

Any other options?

I just cant believe this.
Any help and insight would be greatly appreciated.

Cory


Nov 12 '05 #2
Converting an Access data structure to a SQL Server structure can be
difficult, depending on how the tables were designed and built. There are
tools available to do this, but I generally use the Data Transformation
Service if going to MS SQL Server.

From what I've heard, ASP 3.0 provides much poorer performance than ASP.net.
NOt sure about coverting between the two, you'll probably need to ask that
in an ASP group ... I've merely dabbled in ASP.NET

XML is a method to transfer data between platforms using formatted
text-based streams. Your data provider (i.e. your database) would send you
an XML document, and your application would take/convert/use that XML
document to "read" the data sent by the provider.

There are quite a few hosts that will support Access databases ... Google
should return a good list. However, your ISP service is not entirely
incorrect in their views. Most find that, unless your web site experiences
very low traffic, your Access db will quickly not be up to the task. My ISP
recently stopped supporting Access dbs simply because of the problems they
were having with congestion, performance issues (server tied up with
Jet/Access requests) and complaints from their users of lost/corrupted
databases. If my site were critical to my business, and I couldn't afford to
lose the time spent in restoring from my backup, then I'd certainly consider
going the SQL route ...

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
"cory" <no***@here.com > wrote in message
news:rkMKb.8681 2$6b2.26807@edt nps84...
Hi,
I have an Access database and am having an ASP.NEt application written for
it. It is almost complete. I have a hosting company that I signed up with a month ago but before I did anything I asked them if Access and ASP.NET
would work on their servers, they said yes so I bought in. Now they are
saying my application wont work on their servers using MSaccess and I can
only use SQL or asp 3.0. They are saying Microsoft is trying to keep Ms
Access as a desktop application. The database is done, and the app is
almost done. I have paid alot of money for this application. What are my
options here?

How hard is it to convert an Access Database to SQL? What ramifications
does this have on the ASP.NET part?

How hard is it to convert to asp 3.0?

I was also told XML would work. DOnt know anything about it.

What about other hosts?

Any other options?

I just cant believe this.
Any help and insight would be greatly appreciated.

Cory

Nov 12 '05 #3
Since your application is developed in ASP.NET + MS Access...here are some
thought:

1. Convert DB from Access to Sql Server may be fairly easy, or may be quite
some work, depending on how the db is designed. Tables can be easily
transferred to SQL server, while queries are not. So, if the Access DB and
your app use a lot of queries in Access, you are having trouble to convert
them to either stored procedures in SQL server, or dynamic SQL statement in
your app.

2. Since the app is .NET app, I believe that the data access is based on
ADO.NET, not old ADO/DAO thing, thus, OleDB namespace in .NET is used to
access data in Jet database (Access database). Although OleDB namespace
works with SQL Server, you really should use SqlClient namespace to access
data in SQL Server, SqlClient namespace is specifically designed and
optimized in ADO.NET for SQL Server.

3. Go back to ASP.3.0 does not change the fact that Access is basically
designed as desktop database. Convert ASP.NET to ASP 3.0 may lead to entire
application re-written because of the different application
structure/approach in .NET and pre-.NET technology.

IMO, find a ISP that provides ASP.NET + Access DB service; or convert Access
DB to Sql Server, after all, a server based db is more suitable for web app.

"cory" <no***@here.com > wrote in message
news:rkMKb.8681 2$6b2.26807@edt nps84...
Hi,
I have an Access database and am having an ASP.NEt application written for
it. It is almost complete. I have a hosting company that I signed up with a month ago but before I did anything I asked them if Access and ASP.NET
would work on their servers, they said yes so I bought in. Now they are
saying my application wont work on their servers using MSaccess and I can
only use SQL or asp 3.0. They are saying Microsoft is trying to keep Ms
Access as a desktop application. The database is done, and the app is
almost done. I have paid alot of money for this application. What are my
options here?

How hard is it to convert an Access Database to SQL? What ramifications
does this have on the ASP.NET part?

How hard is it to convert to asp 3.0?

I was also told XML would work. DOnt know anything about it.

What about other hosts?

Any other options?

I just cant believe this.
Any help and insight would be greatly appreciated.

Cory

Nov 12 '05 #4
I feel your pain, so here's a thought...

Let me take a look at your existing Access database, and I'll give you a
free, no obligation time estimate on the conversion to SQL Server. I've
done a few of these recently...the most complex took 57 hours and included a
learning curve I won;t have to climb again...

You can reach me by emailing Kevin [at] 3NF-inc {dot} com. You will get a
SPAMArrest verification email in reply.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

"cory" <no***@here.com > wrote in message
news:rkMKb.8681 2$6b2.26807@edt nps84...
Hi,
I have an Access database and am having an ASP.NEt application written for
it. It is almost complete. I have a hosting company that I signed up with a month ago but before I did anything I asked them if Access and ASP.NET
would work on their servers, they said yes so I bought in. Now they are
saying my application wont work on their servers using MSaccess and I can
only use SQL or asp 3.0. They are saying Microsoft is trying to keep Ms
Access as a desktop application. The database is done, and the app is
almost done. I have paid alot of money for this application. What are my
options here?

How hard is it to convert an Access Database to SQL? What ramifications
does this have on the ASP.NET part?

How hard is it to convert to asp 3.0?

I was also told XML would work. DOnt know anything about it.

What about other hosts?

Any other options?

I just cant believe this.
Any help and insight would be greatly appreciated.

Cory

Nov 12 '05 #5
Tom
I write in ASP 3.0 and use MsAccess DB's but for very small traffic
sites. I agree if you expect any traffic you should go ahead and move
up to MySQL or SQLserver whichever the host allows you to use.

Since your data isn't too far along your developer should be able to
do the switch over for you.
Nov 12 '05 #6
no********@Remo veThis.shaw.ca (Norman Yuan) wrote in
<XBWKb.15883$X% 5.13218@pd7tw2n o>:
IMO, find a ISP that provides ASP.NET + Access DB service; or
convert Access DB to Sql Server, after all, a server based db is
more suitable for web app.


Every single web app should use a server-based db?

Or do you really mean "a server-based db is more suitable for
medium- to large-volume websites, especially with large populations
of simultaneous connections and heavy write load. On the other
hand, smaller numbers of simultaneous connections and read-only web
pages can be run very well against Jet back ends."

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #7
On Wed, 07 Jan 2004 20:10:13 GMT, dX********@bway .net.invalid (David W.
Fenton) wrote:
no********@Rem oveThis.shaw.ca (Norman Yuan) wrote in
<XBWKb.15883$X %5.13218@pd7tw2 no>:
IMO, find a ISP that provides ASP.NET + Access DB service; or
convert Access DB to Sql Server, after all, a server based db is
more suitable for web app.


Every single web app should use a server-based db?

Or do you really mean "a server-based db is more suitable for
medium- to large-volume websites, especially with large populations
of simultaneous connections and heavy write load. On the other
hand, smaller numbers of simultaneous connections and read-only web
pages can be run very well against Jet back ends."


What I've heard from people who have done it is that Web apps bog down with
Access back-ends under pretty light loads because Jet is not multi-threaded.
The concensus seems to be that you'll eventually need a server back-end for
most Web apps, so it's easier if you go ahead and start out that way.
Nov 12 '05 #8
Amen

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access
"Steve Jorgensen" <no****@nospam. nospam> wrote in message
news:rq******** *************** *********@4ax.c om...
On Wed, 07 Jan 2004 20:10:13 GMT, dX********@bway .net.invalid (David W.
Fenton) wrote:
no********@Rem oveThis.shaw.ca (Norman Yuan) wrote in
<XBWKb.15883$X %5.13218@pd7tw2 no>:
IMO, find a ISP that provides ASP.NET + Access DB service; or
convert Access DB to Sql Server, after all, a server based db is
more suitable for web app.
Every single web app should use a server-based db?

Or do you really mean "a server-based db is more suitable for
medium- to large-volume websites, especially with large populations
of simultaneous connections and heavy write load. On the other
hand, smaller numbers of simultaneous connections and read-only web
pages can be run very well against Jet back ends."


What I've heard from people who have done it is that Web apps bog down

with Access back-ends under pretty light loads because Jet is not multi-threaded. The concensus seems to be that you'll eventually need a server back-end for most Web apps, so it's easier if you go ahead and start out that way.

Nov 12 '05 #9
"Steve Jorgensen" wrote
What I've heard from people who have
done it is that Web apps bog down with
Access back-ends under pretty light loads
What's a "pretty light load"? Would it be fewer concurrent users than can
use an Access multiuser application with satisfactory performance? I
seriously doubt it, and that number can be up to 100+. That's not enough for
"the next Amazon", but I would venture that few websites on the Net
consistently have enough users to put a strain on it.
because Jet is not multi-threaded.
Again, if that's not a problem with 75 concurrent users on a LAN, why would
it be a problem with 75 concurrent users on a website (short of the web
developers not knowing much about database and using it in an abominable
fashion)?
The concensus seems to be that you'll
eventually need a server back-end for
most Web apps, so it's easier if you go
ahead and start out that way.


That's a generalization, that, like many generalizations , can throw you
off-track -- I'd disagree that _most_ Web apps will outgrow a Jet database.
Some will, but many will not.

Use appropriate technologies... that's the ticket.

Larry Linson
Microsoft Access MVP

Nov 12 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
7705
by: Gary Dale | last post by:
I have a database that was originally set up in Access 97 (because that was what we had in the office). We had a copy of Access 2000 set up on one machine for a brief period to get at another database that required it. Unfortunately someone used that machine and "upgraded" the Access 97 database to Access 2000. Now I'm trying to get it back to Access 97 but the "convert to prior version" function keeps telling me that it can't convert...
12
2221
by: dixie | last post by:
Can someone familiar with Access 2003 please answer this question? I am asking because I don't have the use of A2003. When Access 2003 finds an Access 2000 database, does it come up with some sort of question/suggestion indicating that you can convert this datbase into the new format? I am trying to trouble shoot a remote site where a big error message indicating the database was converted using the wrong method comes up when they try to...
3
2408
by: Dori | last post by:
hi, trying to convert access 97 to access 2003 with the access 2003 convertion tool of microsoft, but the only thing that isn't convert is the modules in the vb of access 97. what should i do ? i need it urgently?
3
2708
by: ET | last post by:
I don't know whats the problem, but after I added functions to first verify, then relink linked tables if not found, now I can't convert that database to MDE format. I can split the database, but can't convert part of the database with forms, reports, queries to MDE format. Can somebody advice on this? References, in the order, from the top:
3
2875
by: Jon S via DotNetMonster.com | last post by:
Hi all, Is there a way to convert an Access.mdb from one format (say Access '97 or Access 2000) to Access 2002 format using ADO.NET and C#??? I know how to do it manually using the Access DBMS but I would like to know how to do it programatically. I don't have any idea if this can be done so if it can please could someone show the code to do it or provide links so I can read up on how to do it.
3
12946
by: Bill Nicholson | last post by:
What tools are available to convert Access projects (Forms, Code, Queries, Reports) to VB Dot Net? Does anyone have experience with this type of conversion? Please tell me I don't have to do it by hand! Thanks, Bill
2
1278
by: Mamatha | last post by:
Hi I want to convert SQLServer database into MS-Access through ASP program.Is there any possiblity to covert?If possible please let me know and thanks in advance. Mamatha
5
2582
by: melickas | last post by:
We designed a custom application using Office Developer Tools '97 which included a Run-time version of Access--- so it would not matter if our customer even had any version of Access on their computer. The application ran without problems on our customer's computer for 2-3 years. Then our customer bought a new computer and we had to reinstall the application. Everything was ok for approximately 6 months until our customer was "cleaning up"...
6
2236
by: tombsy | last post by:
Hello Group. I work for a company who is about to embark on a long awaited Office upgrade from Office 97 to Office XP. Office XP comes with Access 2002. I am an accomplished Access developer so I have read up on the complexities of upgrade in the corporate environment. Also the need to carry out a full MDB audit to get rid of the redundancy etc etc
0
9825
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
9671
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10846
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...
1
10595
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
10254
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9379
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...
1
7793
isladogs
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...
0
6979
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
5828
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.