Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Access Data_Types in ASP adSchemaColumns

Posted on 2004-04-11
7
Medium Priority
?
368 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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 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…
Integration Management Part 2
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

581 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