Solved

Connecting to an access database on the internet using DAO

Posted on 2001-06-24
7
170 Views
Last Modified: 2010-05-02
Hi,
is it possible to connect to a database on the internet using dao?
Thanks in advance,
0
Comment
Question by:Benjy
7 Comments
 
LVL 1

Expert Comment

by:iProgram
ID: 6222552
Here is my idea:
1.Set the mdb file in Server to SHARE.
2.Set remote DNS in your DAO connection.
0
 
LVL 1

Author Comment

by:Benjy
ID: 6222666
please be more clear.
I usually connect to db with the following code:
SET dbname = OPENDATABASE (db path)


0
 
LVL 14

Expert Comment

by:Matti
ID: 6222718
Hi!

No no, DAO is not for that purpose!

What kind of Access database, how many connections?
Indexes, Tables, the estimated size of it?

Is the server in your own control?

Complex indexes for the database and it will work slow if there is IP protocol. DAO can be used whit client backend connections in certain situations, but problems on remote connections, impossible if the files or documents on internet server. They do not physically exist there, in these http://www. .... addresses and client DAO cannot not found them.
 
Only way is to use IP: 192.168.123.136\mydata\myDB.mdb

The question is, does the macine let your database use this kind of addresses, Fullcontrol in that share for the Access ldb-files, then there might just be too many security holes in that macine to be in the Internet.

ADO OLEDB or RDO if you have Ent version of VB
On RDO you need to run server/client aplications.

Most likely you need to install an ODBC system data source on the server macine, then connect it using ADO or ODBC JET to connect it

If you have resources to make aps application, it is very common option in these situations.


Matti

0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 6223309
hearing...
0
 

Expert Comment

by:shawo
ID: 6223363
Benjy,

hhmmmp, i think, you know, you cant connect to a database using or on the internet. Because, ADO is the one used in accessing the database. But to access a database using an internet, i think it cant be... i'm sorry. but if there's a possible way, i'll try to get the info for u.

shawo
0
 
LVL 14

Accepted Solution

by:
Matti earned 100 total points
ID: 6224374
Hi!

http://members.tripod.com/svw27/gastenboek/

There is a very simple asp database application.

Take the readme.txt it's mainly about those conditions which is needed to run web databases.

Think about the driver needs of clients browser.


Matti
0
 
LVL 1

Author Comment

by:Benjy
ID: 6275105
Sorry for the very long dellay.
I never managed to actually do what I wanted so I sort of forgot about accepting an answer. (I do appreciate your time)
Thanks again.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now