473,405 Members | 2,349 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,405 software developers and data experts.

How to get an Access database on the web from my own computer

How to get an Access database on the web from my own computer

I have an Access database project in inetpub/wwwroot/Access2 . I build it,
and then press cntrl-F5. - I still get the development server - Version
Information:
ASP.NET Development Server 8.0.0.0, instead of IIS.

This is a serious problem. How does one get an Access database on the web,
using one's own computer(I have windows xp pro).

dennist685
Dec 5 '05 #1
12 2092
You want to know how to access it? You can use ADO.NET and the Jet
data provider. Those are good keywords to google.

Dec 6 '05 #2
Hi Dennist,

Welcome.
From your description, when you start running your web application which
located in IIS, you always see that it is started in VS2005 development
server (rather than iis )?

One thing we can check is whether you're opening the web site through IIS
(http) or filesystem? If we open a website through filesystem, then no
matter it is a virtual dir in IIS or not, the VS2005 will always use
internal developmente server to run it..... So please make sure you opened
the website through HTTP.....

BTW, I'm also curious at why don't you put access database file in web
application's App_Data folder? This is the recommended location where we
store the database files for web application.......

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)


--------------------
| Thread-Topic: How to get an Access database on the web from my own
computer
| thread-index: AcX5mQM0lJvs0m/wQ5CSptiyzbT6eA==
| X-WBNR-Posting-Host: 85.64.247.206
| From: "=?Utf-8?B?ZGVubmlzdDY4NQ==?=" <de********@newsgroup.nospam>
| Subject: How to get an Access database on the web from my own computer
| Date: Mon, 5 Dec 2005 04:40:02 -0800
| Lines: 11
| Message-ID: <02**********************************@microsoft.co m>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:362727
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| How to get an Access database on the web from my own computer
|
| I have an Access database project in inetpub/wwwroot/Access2 . I build
it,
| and then press cntrl-F5. - I still get the development server - Version
| Information:
| ASP.NET Development Server 8.0.0.0, instead of IIS.
|
| This is a serious problem. How does one get an Access database on the
web,
| using one's own computer(I have windows xp pro).
|
| dennist685
|

Dec 6 '05 #3
Thank you,

I fail to see how creating a windows form can get my access database on the
web. This is probably due to my ignorance, but I thought that was what
asp.net was for. Could you be so kind as to be more specific?

Perhaps point me to a sample or walkthrough, or an article. I've done a lot
of searching. There are books that'll answer the question - I'm speaking of
asp.net 2.0 and visual studio vs 2005 - but they won't be published until
January through April of next year.

Much appreciated.

dennist685
Dec 6 '05 #4
Steven'

First, in the future, I'll put the database in the app_data folder.

Try as I could, once the application was open, I couldn't find whether it
was http or file system. Could you tell me how to do that?

dennist685
Dec 6 '05 #5
Thanks for your quick response Dennist,

And for how to open web project, it is choosed at the begining when we open
a website in vs 2005. Here is the steps:

1. File---> Open WebSite

2. In the opened "Open WebSiteDialog", there will appear several buttons in
the left view, they're:

FileSystem, Local IIS, FTP Site, Remote Site....

We should choose LOCAL IIS, and specify the HTTP url of our web application
(in the IIS)

this will make it be opened as IIS hosted web application rather than file
system....

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)


--------------------
| Thread-Topic: How to get an Access database on the web from my own
computer
| thread-index: AcX6MN0Mj4a6enbNQUOdE5uacokxCA==
| X-WBNR-Posting-Host: 192.117.113.41
| From: "=?Utf-8?B?ZGVubmlzdDY4NQ==?=" <de********@newsgroup.nospam>
| References: <02**********************************@microsoft.co m>
<Sl**************@TK2MSFTNGXA02.phx.gbl>
| Subject: RE: How to get an Access database on the web from my own computer
| Date: Mon, 5 Dec 2005 22:47:02 -0800
| Lines: 8
| Message-ID: <4E**********************************@microsoft.co m>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:362957
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Steven'
|
| First, in the future, I'll put the database in the app_data folder.
|
| Try as I could, once the application was open, I couldn't find whether it
| was http or file system. Could you tell me how to do that?
|
| dennist685
|

Dec 6 '05 #6
Steve, thanks

But how can I find out this information about an already existing project,
the project we're discussing?

dennist685
Dec 6 '05 #7
Steven,

I decided to open a new project. However on the left side, my choices are
only File System, HTTP, and FTP. The default url was
http://localhost/WebSite. I changed that to http://localhost/HS1

Is everything OK so far?

I put the database into C:\Inetpub\wwwroot\HS1\App_Data

I dragged an AccessDataSource and a DetailsView to the Design surface. I
build the solution and website successfully and pressed cntl+F5

I local development server did not appear among the icons.

However the url in IE was http://localhost/HS1/Default.aspx, and at the
bottom of the page was the message local intranet.

I assume by that that I'm still not using IIS and am not on the internet.

dennist685
Dec 7 '05 #8
Hi Dennist,

For already existing ASP.NET application (in .NET 2.0 / VS2005), this is
projectless, so there is not project file which contains such info( IIS or
filesystem), an asp.net 2.0 application(project) is just a normal
folder.... So if we know that the webproject (folder ) has been
configured in IIS, we should choose the (IIS/HTTP) panel to open that site
in IIS through http path rather than point to the physical dir on
filesystem through file path ...........

And if it is contained in an solution, then the solution file may contains
the website's location info(IIS or filesystem...)

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

--------------------
| Thread-Topic: How to get an Access database on the web from my own
computer
| thread-index: AcX6ZCGqHFqBb6KNRGCGtBRkF3QtKg==
| X-WBNR-Posting-Host: 85.64.247.206
| From: "=?Utf-8?B?ZGVubmlzdDY4NQ==?=" <de********@newsgroup.nospam>
| References: <02**********************************@microsoft.co m>
<Sl**************@TK2MSFTNGXA02.phx.gbl>
<4E**********************************@microsoft.co m>
<3V*************@TK2MSFTNGXA02.phx.gbl>
| Subject: RE: How to get an Access database on the web from my own computer
| Date: Tue, 6 Dec 2005 04:54:02 -0800
| Lines: 6
| Message-ID: <27**********************************@microsoft.co m>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:363028
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Steve, thanks
|
| But how can I find out this information about an already existing
project,
| the project we're discussing?
|
| dennist685
|

Dec 7 '05 #9
Steven,

You wrote

So if we know that the webproject (folder ) has been
configured in IIS, we should choose the (IIS/HTTP) panel to open that site
in IIS through http path rather than point to the physical dir on
filesystem through file path

This a bit confusing to me. Where is the IIS/HTTP panel?

dennist685

Dec 7 '05 #10
Hi Dennist,

I meaned the left panel in the dialog popup through
"File--->Open--->WebSite". And there has a "Local IIS" button in the left
bar, yes? When we click it , in the right Panel there will displaying the
current IIS virutal dir hierarchy, yes? Then, we choose the virtual dir we
want to open ...... That's just the way we open the website through
IIS/http....

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
| Thread-Topic: How to get an Access database on the web from my own
computer
| thread-index: AcX7IvYUmJcvYloCSlektRRnmqwBsw==
| X-WBNR-Posting-Host: 85.64.247.206
| From: "=?Utf-8?B?ZGVubmlzdDY4NQ==?=" <de********@nospam.gmail.com>
| References: <02**********************************@microsoft.co m>
<Sl**************@TK2MSFTNGXA02.phx.gbl>
<4E**********************************@microsoft.co m>
<3V*************@TK2MSFTNGXA02.phx.gbl>
<27**********************************@microsoft.co m>
<PE*************@TK2MSFTNGXA02.phx.gbl>
| Subject: RE: How to get an Access database on the web from my own computer
| Date: Wed, 7 Dec 2005 03:40:02 -0800
| Lines: 13
| Message-ID: <3E**********************************@microsoft.co m>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:363322
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Steven,
|
| You wrote
|
| So if we know that the webproject (folder ) has been
| configured in IIS, we should choose the (IIS/HTTP) panel to open that
site
| in IIS through http path rather than point to the physical dir on
| filesystem through file path
|
| This a bit confusing to me. Where is the IIS/HTTP panel?
|
| dennist685
|
|

Dec 8 '05 #11
Steven, aha, that's what you meant.

Yes, that works.

There is the open question of whether this is really on the web, or not, as
I queried in my last post. Since the development server didn't show up, I
assume its being hosted by iis, but I think it is still only being shown on
my computer, not the internet. My cousin, for example couldn't access the
site from his computer, could he?

dennist685
Dec 8 '05 #12
Thanks for your response Dennist,

As long as we choose the LOCAL IIS(http) to open the website in IIS virtual
dir, it is running through IIS rather than VS.NET development server. And
you can find the url in browser is

"http://localhost/vdirname/xxx.aspx....." , it is using the default 80
port of http which is used by IIS default website....

And as for
=============
There is the open question of whether this is really on the web, or not, as
I queried in my last post. Since the development server didn't show up, I
assume its being hosted by iis, but I think it is still only being shown on
my computer, not the internet. My cousin, for example couldn't access the
site from his computer, could he?
=============

I'm afraid this has nothing to do with Vs 2005 or IIS. Actually, whether
the web application is on internet or can be visited by other internet user
depend on your computer's networking setting and environment. If your
computer is published on internet (have a public internet IP address...).
Of course, you can let other people visit your computer and site like:

http://ip address/vdirname/xxx.aspx......

or if you've registered an DNS name ( www.my company.com) for the public
IP address, you can also let other people visit through the DNS name
instead of IP address....

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

--------------------
| Thread-Topic: How to get an Access database on the web from my own
computer
| thread-index: AcX745wg71+nKGrRRl+s9xHbk4a1LQ==
| X-WBNR-Posting-Host: 85.64.247.206
| From: "=?Utf-8?B?ZGVubmlzdDY4NQ==?=" <de********@nospam.gmail.com>
| References: <02**********************************@microsoft.co m>
<Sl**************@TK2MSFTNGXA02.phx.gbl>
<4E**********************************@microsoft.co m>
<3V*************@TK2MSFTNGXA02.phx.gbl>
<27**********************************@microsoft.co m>
<PE*************@TK2MSFTNGXA02.phx.gbl>
<3E**********************************@microsoft.co m>
| Subject: RE: How to get an Access database on the web from my own computer
| Date: Thu, 8 Dec 2005 02:39:04 -0800
| Lines: 11
| Message-ID: <C6**********************************@microsoft.co m>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:363599
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Steven, aha, that's what you meant.
|
| Yes, that works.
|
| There is the open question of whether this is really on the web, or not,
as
| I queried in my last post. Since the development server didn't show up,
I
| assume its being hosted by iis, but I think it is still only being shown
on
| my computer, not the internet. My cousin, for example couldn't access
the
| site from his computer, could he?
|
| dennist685
|

Dec 9 '05 #13

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

Similar topics

13
by: BigDaDDY | last post by:
Um yeah....In case you haven't figured it out, Microsoft sucks. I'm going to be kicked back in my chair eating popcorn and watching football 10 years from now, while all you clowns are scrambling...
11
by: Rosco | last post by:
Does anyone have a good URL or info whre Oracle and Access are compared to one another in performance, security, cost etc. Before you jump on me I know Oracle is a Cadillac compared to Access the...
4
by: Barry Young | last post by:
I have Access 2000 installed on a machine and I create the MDE just fine. When I copy the MDE file over to another machine that has Access 2000 installed, the references are hosed and I get unable...
0
by: Mike Knight | last post by:
(I've also posted this problem on microsoft.public.excel.programming) I have a MS Access 2003 Database named "AS400 Fields.mdb". This database contains links to tables on an AS400. In MS...
4
by: Shawn H. Mesiatowsky | last post by:
I have a strange problem here. I have my development computer with IIS installed, and we have a SQL server as well on a windows 2000 server. both are members of a domain. I have restricted access...
17
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...
17
by: rdemyan via AccessMonster.com | last post by:
With A2003, I'm having trouble accessing files in a folder on another computer where back-end files, update files, etc are located. Here's the scenario: 1) Computer #1 - A2003 2) Computer #2 -...
13
by: Elton Cohen | last post by:
Hi newsgroup! Can anyone tell me where I should put a simple Access database file in order to be accessible for every computer in the network (same workgroup)? There does not need to be any...
4
by: corey11 | last post by:
I'm a very low-level developer with limited VB knowledge but nonetheless was able to put together a very user-friendly and extremely helpful Access 97 database for my company some 10 years back. We...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...
0
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,...
0
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...
0
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...
0
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,...
0
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...

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.