Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access Data_Types in ASP adSchemaColumns

Posted on 2004-04-11
7
Medium Priority
?
367 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 1200 total points
ID: 10801327
The only datatype with a variable field size is text: 0 - 255, default 50
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
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…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

886 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