how to use Record Object

  • Thread starter Thread starter help
  • Start date Start date
H

help

in the ado 2.5 ,there are 2 new object "Record" and "Stream"

we can use Record access website, every Record is a file

how can i use Record Object denote a record in a open Recordset?

I'am a chinese,my english is so bad,who can understand me?

Please answer my question use VBA code,thanks a lot!
 
To the best of my knowledge, you can't use these objects in that way. As I
understand it, they are designed for use with web pages and other such
text-based files, not for use with relational databases.
 
thank you for answer this question

please access this url:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;248255

in the example code ,microsoft can use the Recordset denote a website

rs.Open "test.txt", "Provider=MSDAIPP.DSO;" & _
"Data Source=http://localhost/test", _
adOpenForwardOnly, adLockReadOnly, adCmdTableDirect

and user these code

'Read the current row of the Recordset into a Record
rec.Open rs

if i can use recordset open a table . i can reason out use a Record denote
a Row,is it right?
 
Try the following URLs. According to the article at the first URL, whether
you can use the Record object or not depends on whether the provider
supports it. I'm fairly sure that the JET provider does not support it - I
can find no reference to it in the documentation for the JET provider.

The Record Object:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/adostartpage1.asp

The JET Provider:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/joltspec.asp
 
Back
Top