Solved

Access Data_Types in ASP adSchemaColumns

Posted on 2004-04-11
7
354 Views
Last Modified: 2007-12-19
Helllo Just a quickie

I need to know all access field types + there corosponding Data_types in Names not numbers

and all the default values for each + all max field lengnths for each

Im sure somebody has a hany link tucked away

cheers all.
0
Comment
Question by:Skippythekid
  • 4
  • 3
7 Comments
 
LVL 7

Expert Comment

by:brgivens
ID: 10801245
autonumber: adInteger
text: adVarWChar
memo: adLongVarWChar
byte: adUnsignedTinyInt
integer: adSmallInt
long integer: adInteger
single: adSingle
double: adDouble
replication id: adGUID
decimal: adNumeric
date time: adDate
currrency: adCurrency
yes/no: adBoolean
ole object: adLongVarBinary
hyperlink: adLongVarWChar
0
 
LVL 1

Author Comment

by:Skippythekid
ID: 10801278
Nice one cheers do you know the default field sizes for each and max field sizes ?
0
 
LVL 7

Accepted Solution

by:
brgivens earned 300 total points
ID: 10801327
The only datatype with a variable field size is text: 0 - 255, default 50
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Author Comment

by:Skippythekid
ID: 10801382
ta dude :)
0
 
LVL 7

Expert Comment

by:brgivens
ID: 10801397
Thanks for the points, dude!  :)
0
 
LVL 7

Expert Comment

by:brgivens
ID: 10801813
BTW... I came across this while working on another question & thought it might be useful for you:

Type                         Disk space          Values
------                        -------------         -----------
Text                          Up to 255 bytes   Variable length text
Memo                        Up to 1.2 GB       Large variable length text
Numeric-Byte             1 byte                 0 through 255
Numeric-Integer         2 bytes               -32,768 through 32,767
Numeric-Long Integer 4 bytes               -2,147,483,648 through 2,147,483,647
Numeric-Single          4 bytes               -3.4 x 1038 through 3.4 x 1038
Numeric-Double         8 bytes               -1.8 x 10308 through -1.8 x 10308
Currency                   8 bytes                Numbers with up to 15 digits to the left of decimal point and 4 to the right
Counter                     4 bytes                Automatically incremented long integer
Yes/No                      1 bit                    Boolean data
Date/Time                 8 bytes                Dates and time values
OLE                          Up to 1.2 GB         OLE objects, graphics, and other complex data
Binary                       Up to 1.2 GB         Variable length binary data

1.2GB is the max database size
0
 
LVL 1

Author Comment

by:Skippythekid
ID: 10801865
Nice one cheers m8

its much appreciated :)
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question