[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 185
  • Last Modified:

Connecting to an access database on the internet using DAO

Hi,
is it possible to connect to a database on the internet using dao?
Thanks in advance,
0
Benjy
Asked:
Benjy
1 Solution
 
iProgramCommented:
Here is my idea:
1.Set the mdb file in Server to SHARE.
2.Set remote DNS in your DAO connection.
0
 
BenjyAuthor Commented:
please be more clear.
I usually connect to db with the following code:
SET dbname = OPENDATABASE (db path)


0
 
MattiCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Richie_SimonettiIT OperationsCommented:
hearing...
0
 
shawoCommented:
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
 
MattiCommented:
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
 
BenjyAuthor Commented:
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now