[AccessD] ADO Connection

Jim Lawrence (AccessD) accessd at shaw.ca
Tue Dec 9 09:52:13 CST 2003


Hi MastercafeCTV:

You can see an/some examples of that if you view/download some of the files
from the latest newlettes November 2003, the DBA site:
http://www.databaseadvisors.com/newsletters.htm

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MastercafeCTV
Sent: Tuesday, December 09, 2003 3:50 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] ADO Connection


Our main database is DATOS.MDB and its contain 3 tables dealers / Products /
suppliers
The main server is www.sampaka.org and the users can upload or daownload
files with users_sampaka and pwd ussa5978 this is for FTP access only
(similar to anonymous).
How connect from any ADE/ADP/MDE/MDB with ADO to this database to retrieve
some records? We know that is better download only one record by each time,
and normally this database is for check some fields only. Actually we are
downloading the MDB to each computer and then the final user run our
software locally. But we suposse that work over the main server is more
correct because we have 1 node that actualice everyday the main database.

Thanks



===========================================
MASTERCAFE SL - NIF B-82.617.614
www.mastercafe.com
Deleg. Asturias
Tel 985.88.49.44 / 627.531.764
Fax 627.500.205
info at mastercafe.com
juan at mastercafe.com
Deleg. Madrid
Tel 627.474.285
cecilia at mastercafe.com
===========================================


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: lunes, 08 de diciembre de 2003 21:18
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] ADO Connection


Connect how and what?  What kind of front end are you using?  You can
certainly open recordsets using ADO and you can even create links, although
it's slow.  If you're using an MDB as a front end, though, you can't edit
forms bound to ADO recordsets.  If you explain exactly what you're trying to
do, perhaps someone can help.

Charlotte Foust

-----Original Message-----
From: MastercafeCTV [mailto:mastercafe at ctv.es]
Sent: Monday, December 08, 2003 12:00 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] ADO Connection


Hi group, we are trying to connect an MDB on a remote server with a local
application. We are checking all possibilities and we are running the same
application on ASP in the same server, and run ok.

The question is how connect with ADO from some PC to a remote MDB. We know
the server IP, and the user and password for general access in read mode.

Thanks in advance

Juan

===========================================
MASTERCAFE SL - NIF B-82.617.614
www.mastercafe.com
Deleg. Asturias
Tel 985.88.49.44 / 627.531.764
Fax 627.500.205
info at mastercafe.com
juan at mastercafe.com
Deleg. Madrid
Tel 627.474.285
cecilia at mastercafe.com ===========================================

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list