how to add access database to asp.net application on server

I am trying to learn ASP.net and created an ASP.net application on my
windows 2003 server on my home LAN, and was wondering the correct way to add
an access database to this application ?

Do I just copy it to the application folder, where do I put it ?

Also, how can I allow my application to access this file correctly ?

I know most applications use SQL databases but I am trying to start small
and work my way up to that.

Any help is greatly appreciated. Thanks

--
Tony

Nov 18 '05 #1

Subscribe Reply

1707

Dmitriy Lapshin [C# / .NET MVP]

Hi Tony,

1. Ensure you have Microsoft Jet OLEDB provider installed on your server
2. Copy the database to a folder that is not accessible through Web requests
(that is, either outside the Inetpub folder, or at least disable ALL web
access for that folder in IIS). Not so important for home use, but you can
run into trouble on a bigger project.
3. Employ the System.Data.Ole Db provider to access the database. You will
need a connection string first, please refer to the Microsoft Jet OLEDB
provider documentation on how to build the connection string for that
provider.

Please feel free to ask additional questions if you'll have any.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"TM" <no********@not hing.com> wrote in message
news:O2******** ******@tk2msftn gp13.phx.gbl...

I am trying to learn ASP.net and created an ASP.net application on my
windows 2003 server on my home LAN, and was wondering the correct way to add an access database to this application ?

Do I just copy it to the application folder, where do I put it ?

Also, how can I allow my application to access this file correctly ?

I know most applications use SQL databases but I am trying to start small
and work my way up to that.

Any help is greatly appreciated. Thanks

--
Tony

Nov 18 '05 #2

Awesome dud. That worked like a charm. Thank you
--
Tony

"Dmitriy Lapshin [C# / .NET MVP]" <x-****@no-spam-please.hotpop.c om> wrote
in message news:uL******** ******@TK2MSFTN GP10.phx.gbl...

Hi Tony,

1. Ensure you have Microsoft Jet OLEDB provider installed on your server
2. Copy the database to a folder that is not accessible through Web requests (that is, either outside the Inetpub folder, or at least disable ALL web
access for that folder in IIS). Not so important for home use, but you can
run into trouble on a bigger project.
3. Employ the System.Data.Ole Db provider to access the database. You will
need a connection string first, please refer to the Microsoft Jet OLEDB
provider documentation on how to build the connection string for that
provider.

Please feel free to ask additional questions if you'll have any.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"TM" <no********@not hing.com> wrote in message
news:O2******** ******@tk2msftn gp13.phx.gbl...
I am trying to learn ASP.net and created an ASP.net application on my
windows 2003 server on my home LAN, and was wondering the correct way to

add
an access database to this application ?

Do I just copy it to the application folder, where do I put it ?

Also, how can I allow my application to access this file correctly ?

I know most applications use SQL databases but I am trying to start small and work my way up to that.

Any help is greatly appreciated. Thanks

--
Tony

Nov 18 '05 #3

Similar topics

3042

is ASP the only way for SQL remote access via internet

by: kackson | last post by:

Hi. I would like to access my database outside of my company. I read many documents but they are all pertaining to accessing the database via ASP or some form of web application. Is there no single windows or linux application tht runs natively to access a remote SQL data base? Any advise is appreciated. Thanks!!

Microsoft SQL Server

5906

Access or Visual Studio?

by: Jerome | last post by:

Hi, I'm a bit confused ... when would I rather write an database application using MS Access and Visual Basic and when (and why) would I rather write it using Visual Studio .Net? Is it as easy in Visual Studio to create reports and labels as it's in Access?` The advantage of VS.net is that not every user needs Access, right? And that would eliminate the Access version problem as well I guess.

.NET Framework

4374

Convert an Access database to SQL

by: cory | last post by:

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

Microsoft Access / VBA

5236

Future of access?

by: John | last post by:

Hi What future does access have after the release of vs 2005/sql 2005? MS doesn't seem to have done anything major with access lately and presumably hoping that everyone migrates to vs/sql. Any comments? Thanks

Microsoft Access / VBA

4606

Need info, books, articles,code, etc: Access VBA to XML to/from MySQL via HTTP

by: Cheryl Langdon | last post by:

Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to communicate with a MySQL database table on a web server, from inside of my company's Access-VBA application. I know VBA pretty well but have never before needed to do this HTTP/XML/MySQL type functions.

Microsoft Access / VBA

4408

Ms Access 2003

by: Mell via AccessMonster.com | last post by:

Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting there, but is there a way they can find out if that application was put there from a CD or email or created at work? Hint: It's not on a client/server database, just native jet database mdb created on Access 2003 (default 2000)...

Microsoft Access / VBA

3831

Is This Possible ... ?

by: Wayne Smith | last post by:

I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web site for a small club I belong to and one of the features I would like to include is the ability to allow users to upload image files. unfortunately the servers web root www folder only allows READ and EXECUTE permissions, which makes it...

ASP.NET

2222

Access 95 Upgrade to SQL Server

by: dorpnospam | last post by:

We have an old but very critical application that was written in VB 6 against Access 95 dbs. We need to ditch this decrepit old unstable db platform but we are trying to determine the best migration path to SQL Server. I am researching options. I started by upgrading a sample db to Access 2003 and update the VB 6 app to use DAO 3.6. That works well. Next I tried upsizing the application to SQL Server and that works as well but it...

Microsoft Access / VBA

1947

Upgrading Access 97 application to dotNet

by: kavsak | last post by:

Hi. Not sure that this is the right place to ask but here goes. I have an application based on access97 and VB6 which I need to upgrade. It has to handle up to 20 concurrent users on a Win2k network ( to be upgraded to XP next year) which has no connection to the outside world, but normally there are no more than 2. It has approximately 150 tables with complicated validation rules and a large amount of calculation. I want to rewrite it...

Visual Basic .NET

4095

Need Access database on the web

by: nihad.nasim | last post by:

Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a reliable way of connecting Access to a server. I am willing to switch to any version of Access which might solve the problem. Which server would you recommend and what are the advanatages and disadvantatges of the server you propose? Please also inlcude...

Microsoft Access / VBA

8685

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

8612

Changing the language in Windows 10

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

Windows Server

9032

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

7743

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

6532

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

5869

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

4625

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

3053

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

2008

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