Ever seen Set ds = db.CreateDynaset ?

  • Thread starter Thread starter George Hester
  • Start date Start date
Supposedly it is DAO 2.5 and this is in VB 4.00 16-bit. A msaccess database included in that installation is version 1.x But I have tried getting this in manually to get this CreateDynaset. But it's not working.

http://support.microsoft.com/?kbid=146672

http://www.egynile.com/resources/access/tips/IAccess-12.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;92825

NOTE: This code applies only to Microsoft Access 1.x and 2.0 because later versions lack the Dynaset object and CreateDynaset method.

Well that's that. Need Access 2.0. Surprising since I thought the object library would be sufficient. What object library for DAO comes with Access 2.0?
 
George Hester said:
Supposedly it is DAO 2.5 and this is in VB 4.00 16-bit. A msaccess
database included in that installation is version 1.x But I have
tried getting this in manually to get this CreateDynaset. But it's
not working.

http://support.microsoft.com/?kbid=146672

http://www.egynile.com/resources/access/tips/IAccess-12.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;92825

NOTE: This code applies only to Microsoft Access 1.x and 2.0 because
later versions lack the Dynaset object and CreateDynaset method.

Well that's that. Need Access 2.0. Surprising since I thought the
object library would be sufficient. What object library for DAO
comes with Access 2.0?
Click to expand...

I'm afraid I don't know, though I suspect it's DAO 2.5. But you may be
having problems with compatibility between the object library and the
version of Jet that is installed.

Would you care to explain exactly what you're trying to do? I can't
figure it out from the links you've posted. Are you actually working in
a VB 4.0 installation? Would it work to use a more recent DAO object
library and simply convert the code to the more modern versions of the
objects?
 
What object library for DAO comes with Access 2.0?
Access 2.0 came with DAO 2.0
DAO 2.5 came with the 'Microsoft Access Service Pack'

DAO 2.x (and the DAO 3.5/2.5 compatibility layer) support
the CreateDynaset Method.

CreateDynaset was already obsolete with DAO 2/Jet 2,
it had been replaced with OpenRecordset. However
the help files did not catch up for a while...
But it's not working.
Click to expand...
Are other things working? DAO may not be installed correctly.
Note that with Jet 3, installing Access installs a DAO licence
key, which enables you to use the DAO dbEngine. DAO 2.x
may have a similar requirement.

FWIW: from memory, VB 3 used Jet 1. The 'Compatibility
layer' enabled it to use Jet 2. Jet 2.5 replaced Jet
2 with no compatibility layer required.

(david)



Supposedly it is DAO 2.5 and this is in VB 4.00 16-bit. A msaccess database
included in that installation is version 1.x But I have tried getting this
in manually to get this CreateDynaset. But it's not working.

http://support.microsoft.com/?kbid=146672

http://www.egynile.com/resources/access/tips/IAccess-12.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;92825

NOTE: This code applies only to Microsoft Access 1.x and 2.0 because later
versions lack the Dynaset object and CreateDynaset method.

Well that's that. Need Access 2.0. Surprising since I thought the object
library would be sufficient. What object library for DAO comes with Access
2.0?
 
Yes after VB 3 this CreateDynaset hit the dust barrel.

I had no Project other then trying to get the example to work as written. I know I can change it around if I sit down and put my (mind???) to it. But I was interested in this dynaset stuff as written and so I wanted to see if I could make that available. Couldn't with what I have. My JET and DAO survived the attempt. I wonder if it will if I install Access 2.0 and\or VB 3?

So it's off to eBay it looks like. Thanks for y'all's help in this.

Windows 2000 SP4 updated MDAC (2.7 actually) VB6 SP5 Accesss 2002.
 
Back
Top