Mark Hayes
markH at bitgen.co.uk
Tue Apr 8 11:25:57 CDT 2003
Thanks again :o) Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: 08 April 2003 16:49 To: accessd at databaseadvisors.com Subject: RE: [AccessD] FW: Problem with currentDB in ADP -recordsetsandcurrentproject You miss out on some of the speed of SQL Server and you can't directly manipulate the tables and stored procedures from an MDB. However, if all you want to do for now is move your database to SQL Server, it would be a lot easier for you to make the transition using an MDB. Charlotte Foust -----Original Message----- From: Mark Hayes [mailto:markH at bitgen.co.uk] Sent: Tuesday, April 08, 2003 7:39 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] FW: Problem with currentDB in ADP -recordsetsandcurrent project Thanks Charlotte... What would you think about linking tables from an MDB to the backend instead of creating a project? This would save me re-writing a lot of code, but would I be missing out on much? Cheers... Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: 08 April 2003 16:28 To: accessd at databaseadvisors.com Subject: RE: [AccessD] FW: Problem with currentDB in ADP - recordsetsandcurrent project You have an ADP you converted from an A97 project? Using ADO, you can set the recordset's connection property to CurrentProject.ActiveConnection. You're best best is to get yourself a good book on ADO. Charlotte Foust -----Original Message----- From: Mark Hayes [mailto:markH at bitgen.co.uk] Sent: Tuesday, April 08, 2003 6:27 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] FW: Problem with currentDB in ADP - recordsets andcurrent project Hello again I have an access project which I have created from an access 97 database. I would like to be able to create recordsets etc. but am unsure as to the format. I understand that I need to create connetions etc. but I want to work with the current project. Could you please give an example of working with an ADO recordset from the current project. Think I'm missing something here... Thanks again Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Hayes Sent: 08 April 2003 15:00 To: accessd at databaseadvisors.com Subject: RE: [AccessD] FW: Problem with currentDB in ADP - easy one Thanks Chris... Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Chris Mackin Sent: 08 April 2003 14:57 To: accessd at databaseadvisors.com Subject: RE: [AccessD] FW: Problem with currentDB in ADP - easy one There is no DAO database object in an .adp so CurrentDB() doesn't work. Some DAO code will work in .adp, but not the full package, you'll probably need to convert your code to ADO. Chris Mackin www.denverdb.com Denver Database Consulting, LLC -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark Hayes Sent: Tuesday, April 08, 2003 7:41 AM To: accessd at databaseadvisors.com Subject: [AccessD] FW: Problem with currentDB in ADP - easy one Hello all... This is probably very simple but I've only just started playing with data projects in XP. I am tring to set a db to currentdb but I keep getting the error that the object variable is not set. I have added a reference to dao 3.6 but I still can't use currentdb... E.g debug.print currentdb.name This fails with error 91 object variable not set Thanks in advance Mark --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 _______________________________________________ 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 _______________________________________________ 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 _______________________________________________ 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.470 / Virus Database: 268 - Release Date: 08/04/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.470 / Virus Database: 268 - Release Date: 08/04/2003