StaRKeY
starkey at wanadoo.nl
Sun Jul 11 15:51:56 CDT 2004
Hi Susan, I've read this part also and to be honest... There seem to be so many exceptions with ADO (MDB/ADP) having so many connect options and providers, not to mention known ADO bugs etc... I was already happy I got it to work (again):-) Maybe DAO would be easier?:-) -----Oorspronkelijk bericht----- Van: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] Namens Susan Harkins Verzonden: zondag 11 juli 2004 22:29 Aan: 'Access Developers discussion and problem solving' Onderwerp: RE: [AccessD] Got it! >From Help -- not sure if this answers your question or not. I've been reviewing the differences between Connection and AccessConnection myself this afternoon. Susan H. The AccessConnection property returns an ADO connection that uses two OLE DB providers. It uses the Microsoft OLE DB Provider for Microsoft Jet (Microsoft.Jet.OLEDB.4.0) as the data provider and the Microsoft OLE DB Provider for Microsoft Access 10 (Microsoft.Access.OLEDB.10.0) as the service provider. You should use the AccessConnection property if you intend to create ADO recordsets that will be bound to Access forms. The form will not be updateable unless it is created by using the OLE DB Provider for Microsoft Access 10, even if the recordset is updateable in ADO. Okay, last question can be forgotten:-) The trick is to use a connected ADP and set the connection object to: CurrentProject.AccessConnection. That was all I needed to have my forms act the way they did in the MDB. I still wonder though why I couldn't get it to work using a disconnected ADP and the original code but at least I got it to work...pfew:-) Regards, Eric Starkenburg Starkenburg Office Solutions _____ avast! Antivirus <http://www.avast.com> : Uitgaande bericht is niet besmet. Virus Gegevensbestand (VPS): 0428-1, 09-07-2004 Getest op: 11-7-2004 18:14:40 avast! auteursrecht (c) 2000-2004 ALWIL Software. -- _______________________________________________ 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 _____ avast! Antivirus <http://www.avast.com> : Uitgaande bericht is niet besmet. Virus Gegevensbestand (VPS): 0428-1, 09-07-2004 Getest op: 11-7-2004 22:51:55 avast! auteursrecht (c) 2000-2004 ALWIL Software.