Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default recordset type?
In VBA for Excel 97 the default type of recordset is DOA.
What is the default type on Excel 2000, and XP? I need to know since I don't want the client to have to install the latest MDAC to get my Excel modifications to work. (They supplied the originals, I made modifications, they will maintain them) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default recordset type?
I think you've got the terminology a little back to front. Common database
access technologies include DAO, RDO, ADO in order of history. The recordset type is another thing altogether. DAO is the most mature and flexible. 2.5 is present on everything from 95 to Win 2k. However it's not on XP, or at least it wasn't on a project I was recently involved with. So if you're after pinning your colours to a particular technology I'd go with ADO 2.5. One thing with ADO though is that in order to create databases and do some other administrative type things you need to use ADOX which is another component. Not sure about the availability of this client side. DAO let you do everything in one place. In an attempt to streamline ADO and make it less bulky Microsoft removed these kind of features from ADO. -- Regards, Bill Lunney www.billlunney.com ";-)" wrote in message ... In VBA for Excel 97 the default type of recordset is DOA. What is the default type on Excel 2000, and XP? I need to know since I don't want the client to have to install the latest MDAC to get my Excel modifications to work. (They supplied the originals, I made modifications, they will maintain them) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default recordset type?
Thanks for the reply, I guess I left off some details of my situation.
My clients creates the Excel sheets without any database parts. Their current versions are Win 2K, with Office 2K. I have Win XP pro and Office XP. I only create a callable function inside their Excel sheets that allows me to pass an ADO recordset between their Excel sheets and my VB 6.0 application. (I give them an almost blank recordset, and their Excel code just fills in the blanks). Public Function getRs(ByRef rs As Object) As Object is the function definition I use inside of the Excel VBA. I don't have to do anything different than this. BUT I would prefer to not have to use the "Object" qualifier since this limits their/my use of help functions inside Excel. I do use some properties like .definedSize which would not be obvious to them when I turn maintenance over to them. I got it to work by referencing the rs as and ADO object, but their only engineer smart enough to know how to install the latest MDAC to make it work on his computer left the company. SO would Public Function getRs(ByRef rs As Recordset) As Recordset work on their system with out them having to install anything with the ADO recordset I pass?? "Bill Lunney" wrote in message ... I think you've got the terminology a little back to front. Common database access technologies include DAO, RDO, ADO in order of history. The recordset type is another thing altogether. DAO is the most mature and flexible. 2.5 is present on everything from 95 to Win 2k. However it's not on XP, or at least it wasn't on a project I was recently involved with. So if you're after pinning your colours to a particular technology I'd go with ADO 2.5. One thing with ADO though is that in order to create databases and do some other administrative type things you need to use ADOX which is another component. Not sure about the availability of this client side. DAO let you do everything in one place. In an attempt to streamline ADO and make it less bulky Microsoft removed these kind of features from ADO. -- Regards, Bill Lunney www.billlunney.com ";-)" wrote in message ... In VBA for Excel 97 the default type of recordset is DOA. What is the default type on Excel 2000, and XP? I need to know since I don't want the client to have to install the latest MDAC to get my Excel modifications to work. (They supplied the originals, I made modifications, they will maintain them) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default recordset type?
";-)" wrote in message ... Thanks for the reply, I guess I left off some details of my situation. My clients creates the Excel sheets without any database parts. Their current versions are Win 2K, with Office 2K. I have Win XP pro and Office XP. I only create a callable function inside their Excel sheets that allows me to pass an ADO recordset between their Excel sheets and my VB 6.0 application. (I give them an almost blank recordset, and their Excel code just fills in the blanks). Public Function getRs(ByRef rs As Object) As Object is the function definition I use inside of the Excel VBA. I don't have to do anything different than this. BUT I would prefer to not have to use the "Object" qualifier since this limits their/my use of help functions inside Excel. I do use some properties like .definedSize which would not be obvious to them when I turn maintenance over to them. I got it to work by referencing the rs as and ADO object, but their only engineer smart enough to know how to install the latest MDAC to make it work on his computer left the company. SO would Public Function getRs(ByRef rs As Recordset) As Recordset work on their system with out them having to install anything with the ADO recordset I pass?? They will need MDAC since that installation contains the ADO object definitions however so many core programs use MDAC these days (including Internet explorer IRC) that its probable its already installed. If it isnt installing MDAC is a trivial task. The only complication is that they may have to set the references from their Excel Workbooks if it wasnt already installed. Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
query a recordset | Excel Discussion (Misc queries) | |||
Default reference type | Excel Discussion (Misc queries) | |||
default save as file type does not work | Excel Discussion (Misc queries) | |||
Default file type to open in 2003 | Excel Discussion (Misc queries) | |||
return recordset | Excel Discussion (Misc queries) |