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

Accessing MS access on LAN using ASP

Jerry Maiapu
259 100+
Hi all,

I am pretty new to asp. Though am a self taught programmer especially ASP I wanna ask this question.

I have a an Access 2003 database sitting on a shared drive that I wish to use asp to connect to. I decided to use asp as this databse will be used by about 200 plus staff here.

Before I start can someone be kindful enough to tell me how I should go about connecting the access databse and that is it possible to use ASP on our local Area Network.

Note: We do not have any web server as yet but do have a Domain Server running on Windows Server 2003 OS.

Thank you so much..
Jerry
Jun 4 '10 #1
7 2323
jhardman
3,406 Expert 2GB
You should be able to connect to an Access db over LAN, but you will need a web server to use ASP - even if it is just IIS running on a local computer. To access your db, I would suggest setting up a DSN (control panel - data sources).

Jared
Jun 22 '10 #2
Jerry Maiapu
259 100+
@jhardman
Hi thanks for the helpful infomation.
Ok first of all I do have IIS installed on my local machine and I am able to use http://localhost/foldername/file.asp to allow my asp files to access my db sitting locally but don't know how to make it avialable to users on the LAN. Our LAN is connected to internet however we do not have a web server. We have a backup and domain server. So would you be able to please to me if it is possible to run web services on our current servers?.

You mententioned "To access your db, I would suggest setting up a DSN (control panel - data sources).".

Would you also be kind enough to explain this and how this can be acheived?

I am quite new to asp and db connection over LAN and not really sure what to do.

Thanks in advance.
Jun 23 '10 #3
Jerry Maiapu
259 100+
@Jerry Maiapu
My post is pretty much not attended to may be because of the content or immaturaity of the question or I would not know for sure.

However I found some way of handling this and I thank Jared in attempting to responding to my post..

Thanks
Jun 28 '10 #4
jhardman
3,406 Expert 2GB
sorry, been really busy. Other users on your LAN should be able to connect to your computer as if it were a web server, hopefully that is the solution you found. From your original post I thought the DB was hosted remotely, that's why I suggested the DSN. If you have the db on the same computer that hosts the ASP page, there isn't a big benefit to a making a DSN. Anyway, glad you found a solution.

Jared
Jun 30 '10 #5
Jerry Maiapu
259 100+
@jhardman
Hi Jared,
Thanks for the reply. We'll basically what I was trying bring across was that I am running IIS my local machine to host a dynamic web page I created. The asp page basically connects to a MS database. The asp file(dynamic web-page) is in C:\Inetpub\wwwroot folder.

To access the web page locally (Within Host PC), I use the format:
Expand|Select|Wrap|Line Numbers
  1. "http://localhost/FolderName/myfilename.asp"
in the browser which is perfectly fine.

But my question is "Will the users on the LAN be able to access my web page? If so then using what address in the browser?. Is it using this
Expand|Select|Wrap|Line Numbers
  1. "http://localhost/FolderName/myfilename.asp" 
or another format?

I would very much appreciate your kind response as I am quite new to this area i.e. Hosting Websites locally over a LAN.


Thanks in advance.


Jerry
Jul 2 '10 #6
jhardman
3,406 Expert 2GB
oh, I gotcha. substitute "localhost" with your PC name or your IP address (you might have to check from some of their computers to see which one works). If you have a static IP then using the IP address is ideal. Otherwise your computer name should work. Let me know if this helps.

Jared
Jul 2 '10 #7
Jerry Maiapu
259 100+
I am away from where I stay but I'll let you know as soon as possible.
Jul 5 '10 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

1
hariharanmca
by: hariharanmca | last post by:
How to Shift or Copy Data from Sqlserver to MS Access using Stored procedure I am passing the clint MS Access file path in that i want to insert or update data in that MS Access file using...
1
by: fniles | last post by:
To do a connection pooling for MS Access using OleDBConnection, do I need to include OLE DB Services=-1 in the connection string ? What will the connection string be for connection pooling for MS...
8
by: fniles | last post by:
Can I change the connection time out in VB.Net 2003 and MS Access (using OLEDbConnection) ? When I use Connect Timeout = 60 in the connectionstring, I get an error "Multiple-step OLE DB operation...
3
by: ofilha | last post by:
I need to format a column in excel but would like to do it from Access using VB. I have hacked around and found a few ways to get to the workbook but have a problem getting to the sheet i want. But,...
2
by: ublow56 | last post by:
I am trying to create an ASP application using javascript. I found may ways to connect to Ms Access using VBScript, but I can't find any for the Javascript... Can someone help me??? I just need...
2
by: ernil | last post by:
Hi, I'm using VB 6 and MS Access. My problem is how to create a relationship in Access using VB 6. Thanks. - ernil
18
by: hotflash | last post by:
Hi Mark et All, I understand that you created a very professional document and a similar issue forum out there regarding to Inserting the checkbox value into MS Access using ASP however; I am so...
2
by: shivapadma | last post by:
is it possible to access MS ACCESS using c++? if yes,then how can i access? is it similar to java language? i.e, 1.loading 2.connecting 3.using
4
by: macca | last post by:
hi, Does anybody know if it's possible to log into Outlook Web Access using PHP? I mean, if I have the username, password and email address I need to have a link that opens directly into...
6
by: =?Utf-8?B?QmVu?= | last post by:
Hi all, Is there any good resource online that you can share with me about programming Access using C#. I am trying to get my feet wet with C# and vs2008. I tried looking at kb317114, it...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.