473,326 Members | 2,113 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Stunned !! Access does not provide this?

adLongVarChar to 'text' - Mapping ADO types to Native Access types?
Okay, so it's not the job of Access to map these types, but has
anybody, in the existance of this world ever figured out how to do so?

Does anyone have code that they can share that can correctly map
ADO/ADOX types to the native Access Types, correctly distinguishing
between say 'text' and 'memo'? Even if the routine needs more meta
data from say ADOX such as length, numeric precision and such I'll
take it. I'm stunned that in all the years Access has existed that
this capability does not exists.

Griffo
Nov 12 '05 #1
9 2460
JET (Interface)
DDL type[1]
DAO constant / value
ADOX constant / value

Text
TEXT (size)[2]
dbText
10
adVarWChar
202

Memo
MEMO
dbMemo
12
adLongVarWChar
203

Number: Byte
BYTE
dbByte
2
adUnsignedTinyInt
17

Number: Integer
INTEGER
dbInteger
3
adSmallInt
2

Number: Long
LONG
dbLong
4
adInteger
3

Number: Single
SINGLE
dbSingle
6
adSingle
4

Number: Double
DOUBLE
dbDouble
7
adDouble
5

Number: Replica
GUID
dbGUID
15
adGUID
72

Number: Decimal
DECIMAL (precision, scale)[3]
dbDecimal
20
adNumeric
131

Date/Time
DATETIME
dbDate
8
adDate
7

Currency
CURRENCY
dbCurrency
5
adCurrency
6

Auto Number
COUNTER (seed, increment)[4]
dbLong with attributes
4
adInteger with attributes
3

Yes/No
YESNO
dbBoolean
1
adBoolean
11

OLE Object
LONGBINARY
dbLongBinary
11
adLongVarBinary
205

Hyperlink
[5]
dbMemo with attributes
12
adLongVarWChar with attributes
203

[6]
BINARY (size)
dbBinary
9
adVarBinary
204


--------------------------------------------------------------------------------

[1] There are numerous synonyms for these names, such as CHAR for the TEXT, DATE for DATETIME, SHORT for INTEGER, FLOAT for DOUBLE, LONGTEXT for MEMO, MONEY for CURRENCY. Some synonyms work in limited contexts, e.g. ADO only.

[2] Include the brackets if you specify a size (number of characters).

[3] Not available in the Access query interface or DAO. Use ADO to Execute the DDL query statement.

[4] The initial seed value and increment value are optional, and can be used only with ADO.

[5] The Hyperlink type field cannot be created with DDL.

[6] The fixed-width binary type field cannot be created with the user-interface.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mike" <de**********@hotmail.com> wrote in message news:95*************************@posting.google.co m...
adLongVarChar to 'text' - Mapping ADO types to Native Access types?
Okay, so it's not the job of Access to map these types, but has
anybody, in the existance of this world ever figured out how to do so?

Does anyone have code that they can share that can correctly map
ADO/ADOX types to the native Access Types, correctly distinguishing
between say 'text' and 'memo'? Even if the routine needs more meta
data from say ADOX such as length, numeric precision and such I'll
take it. I'm stunned that in all the years Access has existed that
this capability does not exists.

Griffo

Nov 12 '05 #2
Al*********@SeeSig.Invalid (Allen Browne) wrote in
<3f**********************@freenews.iinet.net.au> :
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

JET (Interface)
DDL type[1]
DAO constant / value
ADOX constant / value


Allen, were you aware that your post was 1544 lines long, because
of incredibly verbose HTML appended at the end?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #3
TC

"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:94***************************@24.168.128.86.. .
Al*********@SeeSig.Invalid (Allen Browne) wrote in
<3f**********************@freenews.iinet.net.au> :
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

JET (Interface)
DDL type[1]
DAO constant / value
ADOX constant / value


Allen, were you aware that your post was 1544 lines long, because
of incredibly verbose HTML appended at the end?


My own objection to HTML is not the length, but the "executablility". Who
knows >what< that rendering engine is doing behind the scenes...

But in this case it's hard to see how the data could have been given in any
other form.

TC

Nov 12 '05 #4
SA
David:

Are you aware how incredibly inane your comments sometimes are? But then I
suppose you hand code all your HTML related posts to reduce their size.

Steve Arbaugh
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:94***************************@24.168.128.86.. .
Al*********@SeeSig.Invalid (Allen Browne) wrote in
<3f**********************@freenews.iinet.net.au> :
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

JET (Interface)
DDL type[1]
DAO constant / value
ADOX constant / value


Allen, were you aware that your post was 1544 lines long, because
of incredibly verbose HTML appended at the end?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 12 '05 #5
a@b.c.d (TC) wrote in <1068954674.809488@teuthos>:
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:94***************************@24.168.128.86. ..
Al*********@SeeSig.Invalid (Allen Browne) wrote in
<3f**********************@freenews.iinet.net.au> :
>Content-Type: text/plain; charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
> JET (Interface)
> DDL type[1]
> DAO constant / value
> ADOX constant / value


Allen, were you aware that your post was 1544 lines long,
because of incredibly verbose HTML appended at the end?


My own objection to HTML is not the length, but the
"executablility". Who knows >what< that rendering engine is doing
behind the scenes...

But in this case it's hard to see how the data could have been
given in any other form.


You've got to be kidding! I was able to read the data just fine in
the text version at the top.

And formats that don't work well in a Usenet post can be put
somewhere for download or on a web page.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #6
~f***********@nspm.com (SA) wrote in
<bp**********@ngspool-d02.news.aol.com>:
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:94***************************@24.168.128.86. ..
Al*********@SeeSig.Invalid (Allen Browne) wrote in
<3f**********************@freenews.iinet.net.au> :
>Content-Type: text/plain; charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
> JET (Interface)
> DDL type[1]
> DAO constant / value
> ADOX constant / value


Allen, were you aware that your post was 1544 lines long,
because of incredibly verbose HTML appended at the end?


Are you aware how incredibly inane your comments sometimes are?
But then I suppose you hand code all your HTML related posts to
reduce their size.


I've never made an HTML post in my life, because there is no
justification for posting HTML on Usenet.

The information Allen wanted to post could have been could have
been conveyed without requiring a 1544-line post.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #7
SA
>>The information Allen wanted to post could have been could have
been conveyed without requiring a 1544-line post.<<

My point (which you seemed to have missed) was BFD........why waste our
collective band width in commenting at all on Allen's post in the first
place?

I'm 99.9% sure Allen was aware that he was posting in HTML (DF: "Allen were
you aware?....") and that it would add overhead to the post. The table and
footnotes were nicely presented; worked great and communicated EXACTLY what
the original requester wanted, or is that not the point of this newsgroup?
Seems the original poster got the information he wanted too since he didn't
request a non-html version of the info be reposted.
There's no justification for posting HTML on Usenet.<<

Oh bullshit, you take this all too seriously; there's HTML everywhere these
days. So maybe it wasn't plain text, who gives a shit, cetainly not the guy
who wanted the info (oh forgot about him). HTML is the tool to use when you
need layout with text to effectively communicate information. An equally
effective layout would have been a pain in the arse to present well in the
line length limits of plain text format without wrapping.

So why do you deem it necessary to comment solely on the format of the help
Allen provided; for some polemical vision about the "purity" of Usenet? For
download speed? (74 kb on dial up may take a second or two but it is not
that big.) Give Allen and the rest of us a break.....

Your post clarified nothing, provided no new or additional information
useful to the original poster and didn't contribute at all to the thread;
hence my point about being inane.

Steve Arbaugh
Posting in Plain Text....
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:94***************************@24.168.128.90.. . ~f***********@nspm.com (SA) wrote in
<bp**********@ngspool-d02.news.aol.com>:
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:94***************************@24.168.128.86. ..
Al*********@SeeSig.Invalid (Allen Browne) wrote in
<3f**********************@freenews.iinet.net.au> :

>Content-Type: text/plain; charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
> JET (Interface)
> DDL type[1]
> DAO constant / value
> ADOX constant / value

Allen, were you aware that your post was 1544 lines long,
because of incredibly verbose HTML appended at the end?


Are you aware how incredibly inane your comments sometimes are?
But then I suppose you hand code all your HTML related posts to
reduce their size.


I've never made an HTML post in my life, because there is no
justification for posting HTML on Usenet.

The information Allen wanted to post could have been could have
been conveyed without requiring a 1544-line post.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 12 '05 #8
~f***********@nspm.com (SA) wrote in
<bp**********@ngspool-d02.news.aol.com>:
The information Allen wanted to post could have been could have been conveyed without requiring a 1544-line post.<<

My point (which you seemed to have missed) was BFD........why
waste our collective band width in commenting at all on Allen's
post in the first place?

I'm 99.9% sure Allen was aware that he was posting in HTML (DF:
"Allen were you aware?....") and that it would add overhead to the
post. The table and footnotes were nicely presented;
No, they were raw HTML in my newsreader, which does not render
HTML, as any RFC-compliant newsreader will not.

HTML does not belong in Usenet posts, period.
. . . worked great
and communicated EXACTLY what the original requester wanted, or is
that not the point of this newsgroup? Seems the original poster
got the information he wanted too since he didn't request a
non-html version of the info be reposted.
What I saw was a text version followed by the HTML code for a
duplicate of precisely the same information.

This is one of the problems with HTML posting, duplication of
information. The other problems are that there are no accepted
standards for how to do it so the creators of newsreaders are just
guessing as to what to do with it.
There's no justification for posting HTML on Usenet.<<


Oh bullshit, you take this all too seriously; there's HTML
everywhere these days. . . .


I don't see it in this newsgroup, nor in any newsgroup I read.
. . . So maybe it wasn't plain text, who gives a
shit, cetainly not the guy who wanted the info (oh forgot about
him). HTML is the tool to use when you need layout with text to
effectively communicate information. . .
No, HTML is what you use when you're creating data to be rendered
by a browser.

That does not apply to Usenet.
. . . An equally effective layout
would have been a pain in the arse to present well in the line
length limits of plain text format without wrapping.
I was perfectly able to understand the text version of the post.
So why do you deem it necessary to comment solely on the format of
the help Allen provided; for some polemical vision about the
"purity" of Usenet? For download speed? (74 kb on dial up may take
a second or two but it is not that big.) Give Allen and the rest
of us a break.....
The HTML was entirely unnecessary and innapropriate. It was also
enormously huge, for no actual benefit.
Your post clarified nothing, provided no new or additional
information useful to the original poster and didn't contribute at
all to the thread; hence my point about being inane.


I asked Allen if he knew that he'd posted HTML. Allen has chosen
not to answer.

Get a clue, Steve: Microsoft did not invent the Internet and does
not control standards. Usenet existed long before Microsoft created
Outlook Express, and there are standards that are supposed to be
followed for Usenet postings. HTML is not part of those standards,
regardless of what Microsoft chooses to put in its poor newsreader.

Secondly, there was no actual benefit to the thousand or so lines
of HTML in that post. None. The information was there in the text
part, and perfectly understandable.

My assumption was that Allen had posted HTML by mistake and would
like to know about it. I probably should have emailed him
privately, yes. Had I done so, your totally unnecessary whining
about my post would have been avoided.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #9
David, this post was intentionally HTML.

It was pasted from a Word document I wrote, and Word does create the most
horrendous HTML. However, if I had to take the time to re-write the thing, I
would not have answered the question.

I broke the rules for a reason: to give the table layout with footnotes, to
give a quick and (I had hoped) useful answer.

Further inforamtion for the original poster: You can get to most of that
information through the Object Browser: F2 in the code window.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:94***************************@24.168.128.74.. .
[snip]
My assumption was that Allen had posted HTML by mistake and would
like to know about it.

Nov 12 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: James Brown | last post by:
Hi all, Having problems designing a template-class. I'll describe my scenario first then show what I've come up with so far: Need a class to provide pointer/array-like access to an area of...
55
by: AnandaSim | last post by:
I just had a google through this NG but have not seen mention of Erik Rucker's blog entry and the new Jet: http://blogs.msdn.com/access/archive/2005/10/05/477549.aspx mentioned by Mike...
4
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The...
3
by: rudodoo | last post by:
My company uses coldfusion to create web applications and we currently are using TOAD as a front end to creating SQL queries. I was wondering how is Access compared to TOAD on its ability to...
1
by: igotyourdotnet | last post by:
Ok, here is the issue: I have 2 web pages one does a file upload to a database and the other page does a FTP to a server, both pages use the c:\temp directory. The page that uploads to a database...
9
by: JT | last post by:
Here is the overall structure I will be referring to: End-program ProvideWorkFlow.dll Forms and methods that properly manipulate calls to methods in AccessUtils AccessUtils (a web service)...
16
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might...
1
by: Peter Duniho | last post by:
On Fri, 11 Apr 2008 01:43:52 -0700, Weeble <clockworksaint@gmail.com> wrote: That's not a difference. The code example you compared to has the implication that A will use the IB instance...
3
by: Stan Brown | last post by:
Okay, so FINALLY I got around to putting a max-width in the header of one page, wrapped in @media screen so that printing is still full width. After being amazed at how much harder it was to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.