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