Francisco H Tapia
my.lists at verizon.net
Tue Apr 8 10:59:00 CDT 2003
Mark, This is *THE* best website I know about for ADO code. http://www.able-consulting.com/tech.htm !YES! you would be missing out on the whole point to moving to a SQL Server database. You see with SQL are your queries are now in the backend, and whenever you need any data you ask sql to get it for you instead of dragging that info accross the network only to not use most of it. Plus OLE-DB is *much* faster than ODBC. It IS a flatter model, but it is designed this way to enable it to be a data access layer for more than one type of connection (ie, Oracle, Jet, Sql, etc). -Francisco http://rcm.netfirms.com On Tuesday, April 08, 2003 8:38 AM [GMT-8], Mark Hayes <markH at bitgen.co.uk> wrote: : 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