469,922 Members | 2,190 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,922 developers. It's quick & easy.

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 1957
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by BigDaDDY | last post: by
11 posts views Thread by Rosco | last post: by
4 posts views Thread by Shawn H. Mesiatowsky | last post: by
17 posts views Thread by Mell via AccessMonster.com | last post: by
17 posts views Thread by rdemyan via AccessMonster.com | last post: by
13 posts views Thread by Elton Cohen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.