[AccessD] FW: Problem with currentDB in ADP - recordsetsandcurrent project

Mark Hayes markH at bitgen.co.uk
Tue Apr 8 10:38:54 CDT 2003


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
 



More information about the AccessD mailing list