Benjy
asked on
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,
is it possible to connect to a database on the internet using dao?
Thanks in advance,
ASKER
please be more clear.
I usually connect to db with the following code:
SET dbname = OPENDATABASE (db path)
I usually connect to db with the following code:
SET dbname = OPENDATABASE (db path)
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\myD
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
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\myD
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
hearing...
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
1.Set the mdb file in Server to SHARE.
2.Set remote DNS in your DAO connection.