Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jeff
Starting Member
6 Posts |
 Posted - 2003-04-10 : 14:21:31
|
| Hi,My question is how will I convert from DAO to ADO the last two lines of codes especially the CreateProperty? What do you think the best alternative code to make this function works?Pls refer to the sample code as shown below:Function SetStartupProperty(prpName As String, prpType As Variant, prpValue As Variant) As IntegerDim dbs As DAO.DatabaseDim prpProp As DAO.Property'lines to be converted from DAO to ADOSet dbs = CodeDbdbs.Properties(prpName) = prpValueSetStartupProperty = True/* lines of codes*/'following lines also needs to be converted from DAO to ADO Err_Prop:Set prpProp = dbs.CreateProperty(prpName, prpType, prpValue)dbs.Properties.Append prpProp |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-04-10 : 20:21:39
|
| HiyaI was just looking at [url]http://p2p.wrox.com/archive/access/2001-09/6.asp[/url] - but I don't think there's going to be a way to do that through ADO. I think you'll have to open the mdb as a DAO database. But you can just include the DAO library and you should be able to code away...Do you have the DAO library included as a reference in your project? Are you using VB or Acess??--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
Access2002 DAO to ADO conversion of CreateProperty