473,382 Members | 1,478 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,382 software developers and data experts.

Connecting to MS access db

Hello I need to connect to an access db which is on the internet. I do
know that URL of the same. its http://www.vallury.com/balance/bank.mdb.
Its just a test db.

How can I connect to that db from either my desktop application or from
my intranet website.

Thanks and Regards


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
1 2496
"Dishaa V" <di****@vallury.com> wrote in message
news:40*********************@news.frii.net...
Hello I need to connect to an access db which is on the internet. I do
know that URL of the same. its http://www.vallury.com/balance/bank.mdb.
Its just a test db.

How can I connect to that db from either my desktop application or from
my intranet website.
Connecting from your desktop, and connection via a website are two complete
different problems.
How can I connect to that db from either my desktop application


ms-access is a file share. Thus, you can't open word, or Excel, or any other
file across the internet. You can open a word file IF YOU transfer the file
to your local computer first..and then open it. So, open the above url..you
can click on it..but in fact you will wind up download a copy to your local
computer.

If you want to "link" to that file..then you need to use the linked table
manger..and YOU MUST BE ABLE to browse to the folder on that pc. That means
you need access to the directory's are that computer (you would need the
admins of the two computers to setup a network link between the two
computers so you could browse via the network neighbourhood to that file).
However, using a file share across the internet is too slow. You can read on
a solution and what the problems are at:

http://www.attcanada.net/~kallal.msn/Wan/Wans.html

or from my intranet website.


If the website is on that server, then those ASP pages can open, and read
and use the mdb file. Of course, with asp pages you are NOT using ms-access,
but only need the jet database engine. (none of your forms etc will work).
However, when using you IIS server, it will still need to be able to open
the mdb file. If you mean how can one web server connect to that mdb file on
another server..then again you have the exact same problem of "linking" to
the back end database (you need to be able to "browse to" the folder..and
open it). So, if you mean how can one web server connect to that mdb
file..then yes..both your questions are exactly the same!
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
pl******************@msn.com
http://www.attcanada.net/~kallal.msn
Nov 12 '05 #2

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

Similar topics

4
by: John Morgan | last post by:
I have Enterprise Manager on my local machine. For the last twelve months it has been connecting without problem to my online SQL Server database provided by my ISP. Three weeks ago the ISP...
12
by: Ann Marinas | last post by:
Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed...
5
by: bill | last post by:
I am having difficulties connecting to a remote Sql server database in VB.net. Lets say my remote server is found at 255.255.255.255 and its name is MyServer. The database is called MyDatabase....
5
by: Sebastian | last post by:
I'm using the following code to connect to an access 2000 database. (with reference to adodb) Public DBvar As New ADODB.Connection() DBvar.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data...
5
by: Al | last post by:
Hi, I am looking for sample VB.net code for working with Access 97 database. I know how to work with SQL but I dont know how to read and writ into access 97. Any help is very much appreciated. ...
4
by: kthiagar | last post by:
Hi I am trying to connect to a password protected access file from VB.NET. I have no problem in connecting to Access, if I remove the password. This is what I am doing: In the server explorer,...
3
by: Laurence | last post by:
Hi there, Does somebody know the efficent way to connect DB2/400? Through iSeries Access ODBC/OLEDB driver or DB2 Connect? Which will more fast and efficent? In addition, does DB2 Connect use...
3
by: Chris | last post by:
Don't know if there is a simple solution for this one or not. When running SQL server on a machine with 2000 loaded and the complete SQL package I don't have any issues. Now I'm trying to login...
3
by: BigZero | last post by:
hello i m new to php i m working on project that has interface with simple html and php i m thinking to use i got some problem with the connecting to DB here is the code for connecting db ...
2
by: franc sutherland | last post by:
Hi, I am trying to build a database in Access 2003 which can connect to information in a SAGE system. Should I use ODBC, and if so, which driver is required? Is there another way of...
1
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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...

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.